If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
combine multiple spreadsheets into one workbook
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? |
#2
|
|||
|
|||
combine multiple spreadsheets into one workbook
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? |
Thread Tools | |
Display Modes | |
|
|