Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Excel Macro help to merge multiple files
Hi,
I am having 3 excel files in a folder and i want to merge the data's to new excel file for eg: file one has 2 worksheets file two has 2 worksheets and i want the data in sheet 1 of file one and file two to be consolidated to a new sheet of a new excel file similarly for sheet 2 of the files. Note: both files don't have constant range of entries in their cells,file one has entries from (A2:U60) and file 2 has entries from (A2:U75) Can anyone help?? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Merge Multiple Single Worksheet Excel Files into one file in separ | Excel Discussion (Misc queries) | |||
how do I merge multiple csv files in one Excel file? | Excel Worksheet Functions | |||
merge multiple worksheets from multiple excel files into oneworksheet | Excel Discussion (Misc queries) | |||
How can I merge multiple sheets from different Excel files workbo. | Excel Worksheet Functions | |||
Merge multiple files into 1 | Excel Programming |