View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
Pete_UK Pete_UK is offline
external usenet poster
 
Posts: 8,856
Default excel: combine several spreadsheets into one workbook

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" wrote in message
...
Thanks Dustin, just tried that and unfortunately the links remain attached
to
the original spreadsheet.

RickS

--
Confused...


"Dustin B" wrote:

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" wrote:

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?
--
Confused...