msharma864512
Member
Hi,
I am looking for a code to consolidate all the excel workbooks.
Steps:
All the spreadsheet will have same set of column headings
All the spreadsheet will be saved in the same folder.
One can just open a consolidated file which will have macro codes, and with the click of a button all the data from different spreadsheets will be added to the master workbook. However, column name shouldn't add.
Regards,
Manish
I am looking for a code to consolidate all the excel workbooks.
Steps:
All the spreadsheet will have same set of column headings
All the spreadsheet will be saved in the same folder.
One can just open a consolidated file which will have macro codes, and with the click of a button all the data from different spreadsheets will be added to the master workbook. However, column name shouldn't add.
Regards,
Manish