Results 1 to 5 of 5

Thread: To explain the macro-enabled working in a file

  1. #1
    Neophyte PRADEEPB270's Avatar
    Join Date
    Oct 2012
    Location
    GURGAON-INDIA
    Posts
    3
    Articles
    0
    Excel Version
    2013

    To explain the macro-enabled working in a file



    Register for a FREE account, and/
    or Log in to avoid these ads!

    A person has sent to me a file which is macro-enabled file.Can anybody help me to understand the file step-by-step that how has he worked out in this file?I am unable to self understand the working of that file.
    For more clarification,please refer the attach file.


    Regards
    Attached Files Attached Files

  2. #2
    It simply reformats the data from multiple lines per part number, and spits it out to a new worksheet with part number on one line, all of its suppliers in adjacent columns.

  3. #3
    Neophyte PRADEEPB270's Avatar
    Join Date
    Oct 2012
    Location
    GURGAON-INDIA
    Posts
    3
    Articles
    0
    Excel Version
    2013
    I want to know the working steps involved in this file.Can you explain me in details of the steps by steps working?

    Thanks in advance.
    Regards

    Pradeep Kumar Gupta

  4. #4
    It creates a dictionary object and adds each Part Code to that dictionary. As it processes each Part it checks if it is in the dictionary, if not, it adds it and its supplier, if it does it just appends the supplier to that dictionary part item.

    Then it dumps the dictionary items into an array, loops the array and splits each element into its component parts and loops through those dropping them all into a single row.

    The last loop can be done in a single statement, without the loop.

  5. #5
    Neophyte PRADEEPB270's Avatar
    Join Date
    Oct 2012
    Location
    GURGAON-INDIA
    Posts
    3
    Articles
    0
    Excel Version
    2013
    Thanks for your solution.
    Regards

    Pradeep Kumar Gupta

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •