combine multiple spreadsheets into one workbook
in [Functions]
|
Prev: Excel 2003 make 1 date cell automatically change another date
Next: Conditional format will not work without $ (removed to allow c
From: Jen on 22 Apr 2010 01:31 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?
From: Duke Carey on 22 Apr 2010 08:12
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 "Jen" wrote: > 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? |