|
|
#1
10-03-2011, 09:13 PM
|
|||
|
|||
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 
|
| 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 |
Windows 7 64bit 
Office 2007
Threaded Mode