Combining 2 workbooks into 1 workbook with TWO sheets

dguenther · #1 10-03-2011, 09:13 PM

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

OTPM · #2 10-06-2011, 03:25 AM

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

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