How to combine or import multiple Excel workbooks?
 

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

How to combine or import multiple Excel workbooks?
 

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

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

How to combine or import multiple Excel workbooks?
 

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?

"David Biddulph" wrote:

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

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

How to combine or import multiple Excel workbooks?
 

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.
--
Thanks,
Shane Devenshire


"Edwin" wrote:

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?

"David Biddulph" wrote:

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

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

How to combine or import multiple Excel workbooks?
 

Hi Edwin

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

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

--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


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

How to combine or import multiple Excel workbooks?
 

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

"ShaneDevenshire" wrote:

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.
--
Thanks,
Shane Devenshire


"Edwin" wrote:

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?

"David Biddulph" wrote:

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

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

How to combine or import multiple Excel workbooks?
 

Ron de Bruin, Thanks. It works !
"Ron de Bruin" wrote:

Hi Edwin

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

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

--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


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