ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Many spreadsheets to one with many tabsheets (https://www.excelbanter.com/excel-programming/312314-many-spreadsheets-one-many-tabsheets.html)

Tommy Vinson

Many spreadsheets to one with many tabsheets
 
Can anyone tell me how to take 15 spreadsheets and make them one, with
each on a seperate tab.

Thanks a million!

Myrna Larson

Many spreadsheets to one with many tabsheets
 
Open the new "master" workbook. Then open each of the other books in turn, and
Edit/Move or Copy Sheet, and say to move it to the new workbook.

On 3 Oct 2004 16:38:27 -0700, (Tommy Vinson) wrote:

Can anyone tell me how to take 15 spreadsheets and make them one, with
each on a seperate tab.

Thanks a million!




All times are GMT +1. The time now is 03:25 PM.

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