merging workbooks
 

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

merging workbooks
 

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

merging workbooks - Thanks
 

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

merging workbooks
 

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