ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Combine tabs from multiple workbooks into one (https://www.excelbanter.com/excel-discussion-misc-queries/43535-combine-tabs-multiple-workbooks-into-one.html)

Alayna

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.

Ron de Bruin

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.





All times are GMT +1. The time now is 02:22 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com