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??
|