Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Combine tabs from multiple workbooks into one
I was given twelve workbooks (one for each month). Each workbook has one tab.
What is the fastest way to combine the twelve workbooks (thus the twelve tabs) into a single workbook? I can open each workbook and move each tab individually, I just thought there might be a more efficient way. Any ideas? Thanks for your help. |
#2
|
|||
|
|||
Hi Alayna
See http://www.rondebruin.nl/copy3.htm -- Regards Ron de Bruin http://www.rondebruin.nl "Alayna" wrote in message ... I was given twelve workbooks (one for each month). Each workbook has one tab. What is the fastest way to combine the twelve workbooks (thus the twelve tabs) into a single workbook? I can open each workbook and move each tab individually, I just thought there might be a more efficient way. Any ideas? Thanks for your help. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
In Excel combine tables from multiple worksheets in to one sheet? | Excel Worksheet Functions | |||
Macro that will add data from multiple workbooks to the 1st open r | Excel Discussion (Misc queries) | |||
linking to multiple workbooks | Excel Discussion (Misc queries) | |||
Is there a way to have multiple rows of tabs? | Excel Discussion (Misc queries) | |||
adding certain cells in multiple worksheets in multiple workbooks | Excel Worksheet Functions |