| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
merge data from multiple excel sheets into a workbook
I need to create a utility in VB which picks up all the excel files
from a specified directory. Assume each of these files have 3 sheets with data (text) in the same format. I need to create a new excel file with similar format containing the 3 sheets and merge the contents from all the source excel files into this new excel workbook. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How can collect data from multiple sheets in the same workbook? | Excel Discussion (Misc queries) | |||
| Transferring data from multiple sheets in workbook to one sheet | Excel Discussion (Misc queries) | |||
| How to merge multiple rows of data to new formated sheets | Excel Discussion (Misc queries) | |||
| Multiple Sheets (Need to create 500 individual sheets in one workbook, pulling DATA | Excel Worksheet Functions | |||
| How can I merge multiple sheets from different Excel files workbo. | Excel Worksheet Functions | |||
![Kamlesh[_3_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
