How to combine or import multiple Excel workbooks?

[Edwin]

I have several workbooks with different types of statistical data. I want to
combine all the workbooks to a single workbook. Is it possible?

 

[David Biddulph]

Yes.
Use the "Move or Copy sheets" option to copy sheets into one workbook.

 

[Edwin]

I have more than a dozen of files. I tried moving it individually. Its time
consuming and Excel closes down. Could you tell me some method with fewer
steps?

 

[ShaneDevenshire]

Hi,

1. Open all the files at once or as many as you choose.
2. Choose Window, Arrange All, Tile
3. To copy the sheet from one workbook to the other hold down the Ctrl key
and drag the sheet tab from the source workbook to the target workbook
3a. To move the sheet from one workbook to another just drag, without the
Ctrl key.

 

[Ron de Bruin]

Hi Edwin

See
http://www.rondebruin.nl/merge.htm

Or see the links to the code examples on the bottom of the page

 

[Edwin]

Shane Devenshire, I find it easy to do. Thanks for the idea. It works!!

 

[Edwin]

Ron de Bruin, Thanks. It works !

Hi Edwin

See
http://www.rondebruin.nl/merge.htm

Or see the links to the code examples on the bottom of the page