| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I merge/combine different workbooks with different sheets
I have several workbooks each with one worksheet. These worksheets are all
named something different. I want to combine/merge these workbooks into one workbook containing all the single sheets. I can't use the "share and merge" because these workbooks were created separtely and not copied from one workbook. I have over a 100 workbooks with 1 sheet per and do not want to copy and past each one. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How do I merge/combine different workbooks with different sheets
See this page for a example Steve
http://www.rondebruin.nl/copy3.htm -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "Steve Descharme" <Steve wrote in message ... I have several workbooks each with one worksheet. These worksheets are all named something different. I want to combine/merge these workbooks into one workbook containing all the single sheets. I can't use the "share and merge" because these workbooks were created separtely and not copied from one workbook. I have over a 100 workbooks with 1 sheet per and do not want to copy and past each one. |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How do I merge/combine different workbooks with different shee
Thanks Ron - That worked great!!
"Ron de Bruin" wrote: See this page for a example Steve http://www.rondebruin.nl/copy3.htm -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "Steve Descharme" <Steve wrote in message ... I have several workbooks each with one worksheet. These worksheets are all named something different. I want to combine/merge these workbooks into one workbook containing all the single sheets. I can't use the "share and merge" because these workbooks were created separtely and not copied from one workbook. I have over a 100 workbooks with 1 sheet per and do not want to copy and past each one. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Merge/Combine address lists | Excel Worksheet Functions | |||
| Combine tabs from multiple workbooks into one | Excel Discussion (Misc queries) | |||
| Combine Workbooks as separate worksheets | Excel Discussion (Misc queries) | |||
| Can I combine 100+ sheets from different workbooks into one worksh | Excel Discussion (Misc queries) | |||
| merge/combine workshhets | Excel Discussion (Misc queries) | |||
Linear Mode
