Hi,
I need a macro to pull the data from different sheets (the columns are not properly alligned) to one single sheet based on the header of the main sheet. but some sheet will have the data in middle of the sheets.
Please find the below data sheets (it has 3 sheets (Main sheet and 2 sample data sheets).
Thanks,
Uday kumar
Last edited by Shanthuday; 08-16-2012 at 02:22 AM. Reason: typo error
Data transfer from data2 to Main sheet looks simple, with the code having to lookup the columns.
What about data1? Will the headers always be in row 18? Should only the data from row 18 n 19 be included in the main sheet?
If I have helped, Don't forget to add to my reputation (click on the star below the post)
Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
Use code tags when posting your VBA code: [code] Your code here [/code]
Nope.. it depends on the customer.. it may be differ from customer to customer.
So should we look for the header from the main sheet in data1? Will the text of the headers match?
That would be better i think, and one more thing is some headers in the data sheet is not as exact as main sheet, so we should also include those condition in the lookup.
Say for an example: Heading "CUSIP" (Data1) should come under column "SecurityNumber" of main sheet and also "Security CUSIP" (Data2) should also pull to same column.
You will need to specify all those conditions.
Please find the attached excel which has the list of items which the customers will update for a particular header.
Also if we can able to map this excel instead writing codes for each condition would really appriciated, which will help the users to change the data in the excel itself instead of code changes.
just to make you to understand the mapping excel which i had sent:
Ex: "Trade Date" is the main heading and the customer can provide it as many ways which is listed under "Trade Date" column.
Will it possible to develop a code to pull the data into main sheet
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks