combine multiple spreadsheets into one workbook

  • Thread starter Thread starter Jen
  • Start date Start date
J

Jen

i have approx 800 individual excel files. i want to put them all into one
excel workbook - creating one workbook with 800 worksheet tabs.
Is this possible without opening them all and dragging them into the one
workbook one at a time?
 
Jen - You may run into a limit on the # of tabs in a workbook. Not sure
about that. Even if there isn't a limit, you are looking at an enormous
amount of memory required to open such a workbook. However, if you want to
try, look at Ron de Bruin's add in that will merge workbooks

http://www.rondebruin.nl/merge.htm
 
Back
Top