• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Data Consolidation from multiple workbooks from in multiple specific sheet in single file

kumars1402

New Member
Hi, need your help, I need to consolidate data from multiple workbooks for diff region named 120, 121, 130, 155 etc, in one workbook with specific names sheet like "Main", "Advance", "IB" and "CC". All these sheets are also in all workbooks.
Need to consolidate in "master". please help with the vba code for this,
 

Attachments

  • 120.xlsx
    9.5 KB · Views: 2
  • 155.xlsx
    9.5 KB · Views: 1
  • 168.xlsx
    9.5 KB · Views: 1
  • Master.xlsx
    8.8 KB · Views: 2
Put all files in the same folder. Use Power Query/Get and Transform to retrieve and combine the appropriate sheets to a query and then load and close to the Master File.
 
Back
Top