merging workbooks

  • Thread starter Thread starter KRK
  • Start date Start date
K

KRK

Hello, I have Excel 2007

I have 3 workbooks that I want to merge into a single workbook, with each of
the originals on a different sheet. I know how to open a clean sheet, but
cannot find out how to import the original workbooks into them.

Help please,

Thanks

KK
 
Open the three workbooks (I will call then A, B and C) and a new workbook
If the original worksheets all have Sheet1 as their worksheet name: right
click each worksheet tab in turn and rename to get three unique names

On the View tab, use Arrange All , specify tiled
Place mouse point on worksheet tab of file A; hold down CTRL button; hold
down left mouse button and drag the tab from A to NewFile; release mouse
button.
Repeat with files B and C

You have copied the three worksheets from A, B and C to NewFile. If you do
not hold CTRL then you will move the sheets (ie A, B and C will lose the
worksheets)
best wishes
 
Thank you, this worked nicely

KK


Bernard Liengme said:
Open the three workbooks (I will call then A, B and C) and a new workbook
If the original worksheets all have Sheet1 as their worksheet name: right
click each worksheet tab in turn and rename to get three unique names

On the View tab, use Arrange All , specify tiled
Place mouse point on worksheet tab of file A; hold down CTRL button; hold
down left mouse button and drag the tab from A to NewFile; release mouse
button.
Repeat with files B and C

You have copied the three worksheets from A, B and C to NewFile. If you do
not hold CTRL then you will move the sheets (ie A, B and C will lose the
worksheets)
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
www.stfx.ca/people/bliengme
remove caps from email
Click to expand...
 
Back
Top