• 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


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

VBA Macro to fill the Excel Template from multiple excel files based on unique value


New Member
I have a excel template which needs to filled with data from different excel files. The unique value is project id.Different excel files contain project id however i have to extract data from different columns.

Please find attached the excel files for reference

1. Final template to fill the data
2. File 1.xlsx
3. File 2.xlsx
4. File 3.xlsx

The order of project id will be different in each files (File 1, 2 and 3). i will fill the project IDs that require data in Final template and the macro should fill corresponding data from different excels.

Request your help


Active Member
You can use Power Query to join the files, but if you need assistance you will need to upload those files to this site.