Do it in batches.

Open bigfile1 and copy the sheets to a new workbook.

Close bigfile1 and open bigfile2.

Copy the sheets from newbook to bigfile2.


Gord Dibben Excel MVP


On 17 Feb 2005 16:25:39 -0800, "Grotifant" wrote:

Hi there

Would anyone know how I can copy some worksheets into another workbook
which is closed. The files are so big that I can't open them both at
the same time.

Thank you very much!
Manuel