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