Results 1 to 1 of 1
  1. #1
    New Lounger
    Join Date
    Aug 2012
    Posts
    1
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Macro code to pull the data from different sheets to main sheet

    Hi,


    I need a Macro which pulls the data from different sheets of excel (which is not formatted properly) to Main Sheet. Also some of the columns will not have the same names (customer will give different names for the columns some time), so macro should handle this exception as well.

    Am attaching the excel which has sample 2 types of sample data and also attaching the excel which has the list of different names which customers will update while providing the data.

    Any help would really appriciated.

    I wanted to pull the data based on the column name mentioned in the main sheet. and mapping sheet has the different names that custome can give (heading the original name in main sheet and the list under the headings are the different names customer can give).

    Thanks,
    Uday Kumar
    Attached Files Attached Files

Posting Permissions

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