Combine Multiple WorkSheets from Multiple WorkBooks into One Workbook into Multiple Sheets.

[brakes78]

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

 

[vladimiratanasiu]

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

Try the Power Query tool: How to Merge [Combine] Multiple Excel FILES into ONE WORKBOOK

 

[brakes78]

Try the Power Query tool: How to Merge [Combine] Multiple Excel FILES into ONE WORKBOOK

I have used the PowerQuery Tool, but the problem that arises when using that is that the data loses the formatting. Which is why i am looking at a VBA resolution.

Cheers!!!!
Brakes78