Sai Prabhu
New Member
I need a macro to consolidate all the data from different Excel files that are present in a folder. All the columns in the files are assumed to be consistent within the same folder; however, the columns can change in different folders. The User should be able to select a folder and the data from all the files should be consolidated into a new singe Excel file (data is copied from a file and pasted one below another)
1. The User should be able to select only Folder Name (all the Excel files within the same folder should be consolidated).
2. Macro should consider all different Excel formats (.xls or .xlsx etc.)
3. The macro should check for data in all the sheets. If exists, copy and paste data below the existing data in the consolidated file.
4. Macro should copy header only from the first file/sheet and rest from row number 2.
1. The User should be able to select only Folder Name (all the Excel files within the same folder should be consolidated).
2. Macro should consider all different Excel formats (.xls or .xlsx etc.)
3. The macro should check for data in all the sheets. If exists, copy and paste data below the existing data in the consolidated file.
4. Macro should copy header only from the first file/sheet and rest from row number 2.
