ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Copy worksheets from one book to another (https://www.excelbanter.com/excel-programming/323483-copy-worksheets-one-book-another.html)

Grotifant

Copy worksheets from one book to another
 
Hi all,

I'm working with two workbooks that are so big that I can't open them
at the same time. Is there a way to copy all the worksheets from file1
to file2 so that the worksheets with the same name than in file1 are
overwritten?

Many, many thanks!

Manuel


Ajtb

Copy worksheets from one book to another
 
Grotifant wrote:
Hi all,

I'm working with two workbooks that are so big that I can't open them
at the same time. Is there a way to copy all the worksheets from file1
to file2 so that the worksheets with the same name than in file1 are
overwritten?

Many, many thanks!

Manuel

Hi
Copy a few at a time to a temporary workbook. Close the first file, open
the second file and then paste them in.

HTH
Andrew B


All times are GMT +1. The time now is 04:09 AM.

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