| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
merging multiple files/sheets into one
I am trying to merge multiple excel files (that all have the same sheet
in them but with different data) into one pre existing excel file. Each file has the same sheet in it but with different data. Do not have to worry about data overwriting. I have seen something like this before but can not remember how to do it with VBA. Thanks! |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
merging multiple files/sheets into one
Hi Stephen
See this page http://www.rondebruin.nl/copy3.htm -- Regards Ron de Bruin http://www.rondebruin.nl wrote in message ups.com... I am trying to merge multiple excel files (that all have the same sheet in them but with different data) into one pre existing excel file. Each file has the same sheet in it but with different data. Do not have to worry about data overwriting. I have seen something like this before but can not remember how to do it with VBA. Thanks! |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
merging multiple files/sheets into one
You can give this a look...
http://www.rondebruin.nl/summary2.htm -- HTH... Jim Thomlinson " wrote: I am trying to merge multiple excel files (that all have the same sheet in them but with different data) into one pre existing excel file. Each file has the same sheet in it but with different data. Do not have to worry about data overwriting. I have seen something like this before but can not remember how to do it with VBA. Thanks! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Merging multiple sheets into one sheet without overwriting data. | Excel Worksheet Functions | |||
| Automated multiple text files into multiple sheets in one workbook | Excel Discussion (Misc queries) | |||
| merging multiple files | Excel Discussion (Misc queries) | |||
| Merging multiple sheets into one sheet | Excel Programming | |||
| merging excel files in different sheets | Excel Programming | |||
Hybrid Mode
