Hi friends when we have large number of excel files with same columns and it is hard to combine it manually to a single excel file .But with the aid of this Vb Macro it is just like a piece of cake.
Put all the excel file in a single folder
Download the Merge Macro File
Open the the file
Enable the macro if you have disabled the macro
Click options and enable it in the security warning showed above in excel.
Click Addin option shown it the excel ribbon
Click open files and select the folder.
Select all the files in the folder by Ctrl+A and click open
You can now see all the files in adjacent sheets.
And now click merge files your files will merge automatically into a single file and copy and save it in a new excel sheet
Note: All excel file should have common column names .
No comments:
Post a Comment