Combining sheets into a new workbook

[benxprezoise]

I have 3 separate workbooks that I need to update monthly with 10 sheets each
and then print 25 of those 30 pages into one report package. The thing is I
cannot combine these workbooks because they are being used for other separate
purposes. What I want to do is create one workbook with all the sheets in the
right order so I can setup a print macro that will print all 25 pages in
order. However I want that workbook summary to be an exact mirror of the 3
workbooks without manually updating it but I would only update the 3 original
workbooks each time. Is this possible?

 

[Dave Peterson]

I think I would combine the workbooks into a new (temporary) workbook.

I'd open each workbook (readonly--so I don't affect other users).

Then copy all the sheets I need from each workbook and put them in that other
workbook. Then I'd close (without saving) those three original workbooks.

Now that copy is mine and I could anything I want to it--including printing and
closing without saving.

If you start a new workbook, you can record a macro when you do this stuff.
Then you can just rerun this macro when you need to do it again (and again and
again).

 

[benxprezoise]

Great idea! Thanks.

--
bpz

I think I would combine the workbooks into a new (temporary) workbook.

I'd open each workbook (readonly--so I don't affect other users).

Then copy all the sheets I need from each workbook and put them in that other
workbook. Then I'd close (without saving) those three original workbooks.

Now that copy is mine and I could anything I want to it--including printing and
closing without saving.

If you start a new workbook, you can record a macro when you do this stuff.
Then you can just rerun this macro when you need to do it again (and again and
again).