| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Moving worksheets to another book - 2nd book will not appear | Excel Discussion (Misc queries) | |||
| copy worksheets to new book without linking to original book | Excel Discussion (Misc queries) | |||
| How many worksheets in a book? | Excel Discussion (Misc queries) | |||
| How do I combine different worksheets into one book? | New Users to Excel | |||
| Copy Worksheets from one book to another? | Excel Programming | |||
Linear Mode
