merging workbooks

[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

 

[Bernard Liengme]

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

 

[KRK]

Thank you, this worked nicely

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
--
Bernard V Liengme
Microsoft Excel MVP
www.stfx.ca/people/bliengme
remove caps from email

 

[Evgeny Grischenko]

Hello!
there is an add-in that you can try - Tables transformer. the link to it is:
http://www.office-excel.com/excel-addins/tables-transformer.html
Hope it helps!

Best regards,
Evgeny