You must have one sheet left in the Workbook when you do this!! You may need
to insert a blank sheet to start with.

Why not open both files, group all the sheets together by holding down the
Shift key and clicking on the last sheet, which will highlight every sheet
from the start to where you are clicking.

Then right click on the grouped sheets and select the Move or Copy option.

In the dropdown box, select the file name where you want the pages to go to.

Select before which current sheet where you want the sheets to appear. Click
OK.

Done.

Try it on a copy first just in case of problems.

Saruman


"LF" wrote in message
...
Hello,

I have a workbook open and I want to populate it with the content of
another xls file. How can I do that. I wan everything transferred: values,
formulas, embedded object, formatting, everyhting. I figured that I coould
do a sheet by sheet copy/paste (of course, enumerating the sheets and
chart sheets in the source document, recreating them in the destination
document and then doing the copy), but I am having a hard time copying
over anything else than values. Also, where are the macros stored? In each
sheet or are they workbook specific? Is there anything else to copy over
to make the opened document identic to the one I am copying from?

Because the destination workbook is already open, I cannot do a SaveCopyAs
on the source workbook and then open that. I need to work with the one
that is already opened.

Any help or guidance is greately appreciated, thank you.

Regards,
Levente