You could try saving the worksheets as .csv - and then importing the
information. That way one of the 'big' files will be a 'not nearly as big'
file. Then you just need to copy/paste special/formats so everything looks
okay...hopefully.

Having said that - if the workbooks are so big, have you considered an
Access DB?

"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