Exporting data from master file to pre-populate many excel files from a template

Hi All,

I've been tasked to try find a VBA solution to export certain data from a master file into a separate template, 3 files attached for reference (Master.xlsm / Template.xlsm / PS00101_North Building_072013.xlsx)

There are 6 rows within the master file and each row represents a project (i.e. 6 projects). I'd like to export data for each project into its own template file which consists of 2 tabs "RAG" & "Financials"

The yellow column data within the master file is to be exported into the yellow "RAG" tab in the template file and orange columns to "Financials" tab.

The 6 populated Template files each need to be saved with the following naming convention ProjRefno_Building name_MMYYYY.xlsx and I've added the PS00101_North Building_072013.xlsx file to show how the end result would look for the first project for the month of July.

Hi Giti

for each Project ref u want separate workbook with relevant data right

ok i m working on same

Hi Gti

try attached file

Paste this both workbook where u want to and copy that path and paste in module & open Master File and click on button

Thanks for the code Naveed works perfectly

I must admit I'm having a hard time understanding what the code is doing but i will play around with it and try adapt it to my actual situation but i think i can follow your logic.

Much appreciated!

Hi Gti

Try the attached workbook and let me know is it what your looking for.

Note: Paste this both attached file in one folder and open the master v2 file and run the macro.

If you are agree and satisfied with solution then please click on Add Reputation below to the post left side

Ok i give me some time right now i am in office , i will get back to u very shortly within 20mins

Just change that red color 4 to 17 and red color 3 to 5

Please Login or Register  to view this content.

Please if you agree and satisfied with the solution then click on Add Reputation below to the post left side

Ok sure , i will give another updated version wait for 10mins i am working on this

Now try this attached version3 files and let me know

if its meet your requirement 100% then click on Add Reputation below to the post left side

Glad to here Gti182, i am very happy by helping you. its happen only because of your good and systematic explanation the credits goes to you Gti182.