ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Combining Worksheets / Seperate Workbooks (https://www.excelbanter.com/excel-discussion-misc-queries/141636-combining-worksheets-seperate-workbooks.html)

kate

Combining Worksheets / Seperate Workbooks
 
I have thirty singular tabbed workbook files that I would like to combine
into one workbook with thirty different tabs. Besides right click €“ move
tab, one at a time, is there a way to do all at once? Thanks.

Barb Reinhardt

Combining Worksheets / Seperate Workbooks
 
This can be done with VBA, but if it's only being done once, it's probably
easier to just do it manually.

"Kate" wrote:

I have thirty singular tabbed workbook files that I would like to combine
into one workbook with thirty different tabs. Besides right click €“ move
tab, one at a time, is there a way to do all at once? Thanks.



All times are GMT +1. The time now is 09:12 PM.

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