Hi All,
Thank you in advance for helping me out here. I am a noob in VBA and have no experience in VBA coding. My issue is that i have to every day/month combine multiple excel sheets from multiple workbooks located in one folder into one consolidated Workbook in Multiple Sheets. For eg. I have to combine the data from Sheet1 of all the workbooks (there could be 1-30 workbooks depending on the day of the month) into the Sheet1 of a master/consolidated file, similarly, for Sheet2, Sheet3, Sheet4............. I've attached a sample of the same, sorry I had to 'X'out the data. I hope I was able to clearly state what is needed to be done here........
Thank you all once again in advance for all the help and hard work.
Cheers!!!!
Brakes78
Thank you in advance for helping me out here. I am a noob in VBA and have no experience in VBA coding. My issue is that i have to every day/month combine multiple excel sheets from multiple workbooks located in one folder into one consolidated Workbook in Multiple Sheets. For eg. I have to combine the data from Sheet1 of all the workbooks (there could be 1-30 workbooks depending on the day of the month) into the Sheet1 of a master/consolidated file, similarly, for Sheet2, Sheet3, Sheet4............. I've attached a sample of the same, sorry I had to 'X'out the data. I hope I was able to clearly state what is needed to be done here........
Thank you all once again in advance for all the help and hard work.
Cheers!!!!
Brakes78
Attachments
-
Consolidated Sales Sheet 1.png91.8 KB · Views: 21
-
Consolidated Sales Sheet 2.png86.9 KB · Views: 23
-
Consolidated Sales Sheet 3.png85 KB · Views: 20
-
Consolidated Sales Sheet 4.png97.6 KB · Views: 23
-
Sales Sheet 0301_Sheet1.png90.7 KB · Views: 17
-
Sales Sheet 0301_Sheet2.png90.7 KB · Views: 19
-
Sales Sheet 0301_Sheet3.png92.2 KB · Views: 17
-
Sales Sheet 0301_Sheet4.png100.8 KB · Views: 19
-
Sales Sheet 0302_Sheet1.png93.3 KB · Views: 19
-
Sales Sheet 0302_Sheet2.png84.8 KB · Views: 17
-
Sales Sheet 0302_Sheet3.png80.9 KB · Views: 15
-
Sales Sheet 0302_Sheet4.png93.7 KB · Views: 15
-
Sales Sheet 0303_Sheet1.png87.1 KB · Views: 16
-
Sales Sheet 0303_Sheet2.png93.1 KB · Views: 14
-
Sales Sheet 0303_Sheet3.png92.5 KB · Views: 13
-
Sales Sheet 0303_Sheet4.png100.9 KB · Views: 24