Opening workbook as sheet inside multi-sheet document

[Karl]

Hi,

Instead of having lots of separate workbooks, each
consisting of a single sheet, to track my monthly work,
I've created one multi-sheet workbook. This workbook,
though, currently consists only of sheets I've created
from scratch.

What I'd like to do now is open some of my older workbooks
inside the new multi-sheet workbook, so that their
contents are displayed as just another sheet. That way I
can create a template, with referenced cells, which I can
use each month (dispensing with all the old separate
workbooks)

I can't figure out how to do it, though, can any one help.

Thanks

Karl

 

[Frank Kabel]

Hi
the best you could achieve is copy/merge these sheets. To do this:
- open both workbooks
- in the source workbook right-click on the tab name, choose Move/Copy
- select the target workbook and the location

For a macro solution you may take a look at:
http://www.rondebruin.nl/copy3.htm

 

[Guest]

Thanks, that was just what I needed.

-----Original Message-----
Hi
the best you could achieve is copy/merge these sheets. To do this:
- open both workbooks
- in the source workbook right-click on the tab name, choose Move/Copy
- select the target workbook and the location

For a macro solution you may take a look at:
http://www.rondebruin.nl/copy3.htm

--
Regards
Frank Kabel
Frankfurt, Germany



.

 

[BrianB]

Copy the sheets from one workbook to the other ?
Right click the tab then 'Move or Copy'.