#1
|
|||
|
|||
Combining 2 workbooks into 1 workbook with TWO sheets
Hello all,
I am working on a rather long complicated project that is being hung up on this one part. I have 5,000 files- there are 2,500 "A" files and 2,500 "B" files. I need to create 2,500 new "C" files that have the info from the A file in one sheet, and the info from the corresponding B files in another sheet in the same workbook. So, I have discovered utilities that can very nicely combine multiple excel files into just one excel file. But I cannot find a utility/thought on how to combine two excel workbooks (each with one sheet) into 1 workbook with 2 sheets. Ideas? Appreciate it, dguenther |
#2
|
|||
|
|||
Hi
Have a look at the VLOOKUP function. From your post it appears that this will be your easiest option. If you need further guidance having looked at the VLOOKUP function then come back to this forum. Good luck. Tony |
Tags |
combining, vba |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Linking sheets to fetch transactions from sheets to another | waqer | Excel | 4 | 09-01-2011 12:35 PM |
Loop through folder of workbooks and copy range to other workbook | Snvlsfoal | Excel Programming | 3 | 07-29-2011 05:55 AM |
macro to transfer data from one workbook to another workbook | virsojour | Excel Programming | 5 | 02-01-2011 08:58 PM |
How do I merge data from one sheet in a workbook out into multiple sheets | nolesca | Excel | 4 | 06-07-2010 08:13 AM |
Select a range in one one workbook while working in other workbook | Slow&Steady | Excel | 1 | 02-21-2010 03:34 AM |