excel: combine several spreadsheets into one workbook

[RickS]

I need to combine several spreadsheets into one workbook. Each spreadsheet
has internally 2 worksheets that have links between the 2.

If I copy each individual spreadsheet into the common workbook, won't the
links be messed up?

 

[Dustin B]

If you keep the worksheet names the same and don't combine all the info into
one sheet in the new workbook you should be able to just copy the info over
and have it work still.

 

[RickS]

Thanks Dustin, just tried that and unfortunately the links remain attached to
the original spreadsheet.

RickS

 

[Pete_UK]

Rather than copy the sheets, move them instead by dragging the sheet tab
from one window to the other. When you do this for the second sheet the
window will close.

Hope this helps.

Pete

 

[RickS]

good morning Pete,

tried several ways to draw and drop the spreadsheet tabs, could never get
the two sessions to be open at the same time... they do appear down on the
bottom navigation bar... any suggestions? Is it a question of a setting on
my Excel?

Rick

 

[Gord Dibben]

Open both workbooks.

Window>New Window

Window>Arrange>Vertical

Close one of the duplicate windows and you are left with your two workbooks side
by side.

Drag a sheet from one to the other.


Gord Dibben MS Excel MVP

 

[RickS]

That worked thanks for you help!

Rick