PDA

View Full Version : How to copy different excel worksheets in one workbook?



Steveclark
04-26-2010, 01:48 AM
I have around 100 different excel workbooks having 1 excel sheet in each workbook. Now i want all these worksheets to be merged in one workbook. How can i do that?

Bob Phillips
04-26-2010, 02:47 AM
ARe they all stored in one folder/directory? Are there any others in there that you don't want?