exporting data from master file to template file (autopopulate a template)

[Gti182]

Hi all,

I'm hoping someone can help me with some code to export from a database to a template which would be manageable to modify and expand on for an amateur level vba user.

I've attached 2 test files, one is the database master file containing the projects (each row represents a project, unique reference number in column A) and the other is the blank template file i'm hoping to export data into and then save down with the naming convention "column A_column B.xlsx"

Kept the test files simple but would need to modify any code to apply to much larger database consisting of many more fields etc.

Thanks
Neill

[Gti182]

this should help, i suppose i'd need to bring in a loop too

Please Login or Register  to view this content.

[Excelnoub]

How do you need to populate your Template?

On double click? with a userform search? I mean you have 4 rows of information in your Master and only space for one project in your template. Do you need to save every row from Master to Template

or

Save individual rows from Master to save in accordance to Column A_B (Copy one row from Master then create new workbook, then add the information in accordance, then save as?)

[Gti182]

Hi Excelnoub

Yes each row/project would populate a template so for this example 4 templates would be populated.

Ideally i'd like the templates to be populated all at once rather than individually as there can be anything up to 300+ projects within the master file to export

[Gti182]

bump back up to page 1

[Excelnoub]

Give me a couple, I have a similar code that does the same thing.

It creates a Folder and then a workbook, just trying to delete the folder part. For the transfer I also have a similar code that will create and paste the information, save then close.
The issue, out of my scope, will be looping through rows and creating each rows vs a new workbook.

[Gti182]

That would be great, i may have some loop code i could try integrate

[Excelnoub]

First, add the following to a module in your Master workbook: this will need tweeking but you will get the idea

This code was provided by shg

Please Login or Register  to view this content.

[Gti182]

wow Excelnoub, have no idea how i'd tweak that to fit my scenario

I did manage to find a mixture of code and tweak it for this example and seems to work as required

Please Login or Register  to view this content.

[Excelnoub]

Nice... I was making a way longer code then expected with Matching / Find. I am at work so limited time frame to play around with it...