Hi,
I need help in merging excel files and creating 1 file. Basically i have multiple excel failes with different names, i end up opening a workbook and add the details from each of the files to the workbook and then run a pivot.
I would be really helpfull if i could just run a macro that would pickup the information from the excel failes from a Folder and add them up in 1 workbook.
Sreejesh
I need help in merging excel files and creating 1 file. Basically i have multiple excel failes with different names, i end up opening a workbook and add the details from each of the files to the workbook and then run a pivot.
I would be really helpfull if i could just run a macro that would pickup the information from the excel failes from a Folder and add them up in 1 workbook.
Sreejesh