Merge (not consolidate) workbooks?

[Ray]

Hello -

I'd like to 'merge' two workbooks ( currently used for different
tasks) into one fully-functional workbook. That is, if WB1 handles
tasks 1-4 and WB2 handles tasks 5-9, I want to create WB3 to handle
tasks 1-9! Each workbook contains approx 15-20 tabs, with lots of
formulas and internal links ....

How would you merge these workbooks without manually re-creating all
of the moved tabs? I tried to cut/paste sheets, but the internal
links automatically became external links ..

all ideas are appreciated!

TIA,
ray

 

[Bill Renaud]

Open both workbooks and arrange the windows horizontally. Then COPY all
of the tabs from WB2 to WB1. To do this, select all of the tabs (click
on the 1st one and shift-click on the last one), then hold down the Ctrl
key while you drag them to WB1. Make sure that you unhide all tabs in
WB2 before copying. Save the final workbook as WB3. You might have a
little bit of "fix-up" to do at the end (named ranges, dynamic charts,
pivot table source data, etc.), but it should be fairly easy. If
something goes wrong during the process, just close all workbooks and
start again.

 

[gimme_this_gimme_that]

Bill's idea might work.

If you have Access you could export the Worksheets to separate tables
in Access and then create a view that has the merged data you want,
the export that into Excel. You might be able to use a database other
than Access.

If you have a lot of data you should be using a database to store the
data anyhow.

Also, with a database solution you can query the data different ways.