| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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? |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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? |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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? |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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? |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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? |
|
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Combine multiple workbooks into 1 workbook w/ multiple worksheets | Excel Discussion (Misc queries) | |||
| Combine multiple workbooks into 1 workbook w/ multiple worksheets | Excel Discussion (Misc queries) | |||
| Combine multiple workbooks into one workbook | Excel Discussion (Misc queries) | |||
| Combine contents of multiple workbooks into one worksheet | Excel Worksheet Functions | |||
| Combine tabs from multiple workbooks into one | Excel Discussion (Misc queries) | |||
Linear Mode
