| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
excel: combine several spreadsheets into one workbook
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... |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
excel: combine several spreadsheets into one workbook
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... |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
excel: combine several spreadsheets into one workbook
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... |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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... |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
excel: combine several spreadsheets into one workbook
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 -- Confused... "Pete_UK" wrote: 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... |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
excel: combine several spreadsheets into one workbook
Open both workbooks.
WindowNew Window WindowArrangeVertical 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 On Thu, 10 Jul 2008 06:22:01 -0700, RickS wrote: 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 |
|
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
excel: combine several spreadsheets into one workbook
That worked thanks for you help!
Rick -- Confused... "Gord Dibben" wrote: Open both workbooks. WindowNew Window WindowArrangeVertical 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 On Thu, 10 Jul 2008 06:22:01 -0700, RickS wrote: 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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to combine 200 spreadsheets | Excel Discussion (Misc queries) | |||
| how to combine workbooks or spreadsheets in to one???? | Excel Worksheet Functions | |||
| Lookup+combine two spreadsheets into third | Excel Discussion (Misc queries) | |||
| How do I combine spreadsheets? | Excel Discussion (Misc queries) | |||
| how do i combine two separate spreadsheets? | Excel Discussion (Misc queries) | |||
Linear Mode
