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

brakes78

New Member
Joined
Apr 27, 2023
Messages
2
Office Version
  1. 2010
Platform
  1. Windows
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
 

Attachments

  • Consolidated Sales Sheet 1.png
    Consolidated Sales Sheet 1.png
    91.8 KB · Views: 21
  • Consolidated Sales Sheet 2.png
    Consolidated Sales Sheet 2.png
    86.9 KB · Views: 23
  • Consolidated Sales Sheet 3.png
    Consolidated Sales Sheet 3.png
    85 KB · Views: 20
  • Consolidated Sales Sheet 4.png
    Consolidated Sales Sheet 4.png
    97.6 KB · Views: 23
  • Sales Sheet 0301_Sheet1.png
    Sales Sheet 0301_Sheet1.png
    90.7 KB · Views: 17
  • Sales Sheet 0301_Sheet2.png
    Sales Sheet 0301_Sheet2.png
    90.7 KB · Views: 19
  • Sales Sheet 0301_Sheet3.png
    Sales Sheet 0301_Sheet3.png
    92.2 KB · Views: 17
  • Sales Sheet 0301_Sheet4.png
    Sales Sheet 0301_Sheet4.png
    100.8 KB · Views: 19
  • Sales Sheet 0302_Sheet1.png
    Sales Sheet 0302_Sheet1.png
    93.3 KB · Views: 19
  • Sales Sheet 0302_Sheet2.png
    Sales Sheet 0302_Sheet2.png
    84.8 KB · Views: 17
  • Sales Sheet 0302_Sheet3.png
    Sales Sheet 0302_Sheet3.png
    80.9 KB · Views: 15
  • Sales Sheet 0302_Sheet4.png
    Sales Sheet 0302_Sheet4.png
    93.7 KB · Views: 15
  • Sales Sheet 0303_Sheet1.png
    Sales Sheet 0303_Sheet1.png
    87.1 KB · Views: 16
  • Sales Sheet 0303_Sheet2.png
    Sales Sheet 0303_Sheet2.png
    93.1 KB · Views: 14
  • Sales Sheet 0303_Sheet3.png
    Sales Sheet 0303_Sheet3.png
    92.5 KB · Views: 13
  • Sales Sheet 0303_Sheet4.png
    Sales Sheet 0303_Sheet4.png
    100.9 KB · Views: 24

Excel Facts

Whats the difference between CONCAT and CONCATENATE?
The newer CONCAT function can reference a range of cells. =CONCATENATE(A1,A2,A3,A4,A5) becomes =CONCAT(A1:A5)
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
 
Upvote 0

Forum statistics

Threads
1,223,181
Messages
6,170,582
Members
452,339
Latest member
mrlong

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top