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

"KRK" wrote in message
...
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

Thank you, this worked nicely

KK


"Bernard Liengme" wrote in message
...
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

"KRK" wrote in message
...
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

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

Best regards,
Evgeny
"KRK" wrote in message
...
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