Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Consolidating multiple files into 1 target
I have 4 different files that I want to merge into one.
The data set is gigantic so I wanted to create a macro to do the dirty work for me. The three files each of keys. 1 file is 1 key the 2nd file is the 2nd key and the 3rd file is the one that matches the first and second keys to give me a name. Now I want to get the information from all of these onto one file. So basically im asking is how to go about matching them up. I need them to be matched and then the corresponding row be added into the already existing row in the target file. THANK YOU!!! |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Consolidating multiple files into 1 target
paste the first and second keys into a single file, (column A and Column B)
then make a concatenated column in column C of the first and second key (Column A and B). Make a similar column in column A of the third file (insert a new column A). (if necessary) Now use the vlookup function using the values in column C of the combined file to lookup the values in the third file using column A as the key. -- Regards, Tom Ogilvy Mark wrote in message ... I have 4 different files that I want to merge into one. The data set is gigantic so I wanted to create a macro to do the dirty work for me. The three files each of keys. 1 file is 1 key the 2nd file is the 2nd key and the 3rd file is the one that matches the first and second keys to give me a name. Now I want to get the information from all of these onto one file. So basically im asking is how to go about matching them up. I need them to be matched and then the corresponding row be added into the already existing row in the target file. THANK YOU!!! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Consolidating multiple worksheets into one | Excel Worksheet Functions | |||
need help in consolidating multiple data | Excel Discussion (Misc queries) | |||
Consolidating multiple sheets | Excel Discussion (Misc queries) | |||
Consolidating multiple workbooks | Excel Worksheet Functions | |||
Consolidating multiple files using a row column range | Excel Programming |