Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Consolidating multiple worksheets into one
If I had 500 different worksheets with one tab each, how would i go
about consolidating all 500 worksheets into 1 worksheet with 500 tabs? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Consolidating multiple worksheets into one
You can copy a worksheet to another open workbook. That's the best way. Maybe
a macro would automate this? I thought there was a limit on the number of worksheets in a workbook, though. It used to be 256. Has the limit been upped with newer versions? I imagine so, but haven't investigated. Jane " wrote: If I had 500 different worksheets with one tab each, how would i go about consolidating all 500 worksheets into 1 worksheet with 500 tabs? |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Consolidating multiple worksheets into one
Try the code/download on this page
http://www.rondebruin.nl/fso.htm Memory is the limit of how may sheets are possible -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm wrote in message ... If I had 500 different worksheets with one tab each, how would i go about consolidating all 500 worksheets into 1 worksheet with 500 tabs? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Consolidating worksheets | Excel Worksheet Functions | |||
Consolidating multiple worksheets into one. | Excel Discussion (Misc queries) | |||
Consolidating worksheets | Excel Discussion (Misc queries) | |||
Consolidating multiple worksheets | Excel Discussion (Misc queries) | |||
Consolidating entries from multiple worksheets | Excel Worksheet Functions |