| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Merging all the sheets in the folder
Please can you help me how can I merge all the excel files to a new
different worksheet named destination. All the files are of the same format having same columns. regards sanju |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Merging all the sheets in the folder
Hi Sanju,
Two options 1) if all the files are exactly the same you can summarize them in your destination file =sheet1!A1+Sheet2!A1... 2) see Ron macro http://www.rondebruin.nl/copy2.htm http://www.rondebruin.nl/copy3.htm "sanju" wrote: Please can you help me how can I merge all the excel files to a new different worksheet named destination. All the files are of the same format having same columns. regards sanju . |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Merging different sheets | Excel Worksheet Functions | |||
| Merging several workbooks from folder to 1 workbook in different s | Excel Programming | |||
| Merging sheets | Excel Worksheet Functions | |||
| merging sheets | Excel Worksheet Functions | |||
| merging sheets | Excel Discussion (Misc queries) | |||
![sanju[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
