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

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