Create new workbook from template with data from existing workbook

[exoremmy]

Hi there,

I have a workbook with data whereby I need to create a new workbook from each row to populate specific fields within a pre made/template workbook.

I would like to be able to do this automatically.


I'm aware that I would need to use VBA and macro's to be able to do this?

I'm using Excel 2013 and would appreciate any help on how to do this.

Many thanks!

 

[svendiamond]

We would need to know more details! Get the values you need from each row into variables... open your template, put these variables into the fields needed, then save as!

 

[exoremmy]

Hi!

Appreciate the reply.

I've uploaded the source excel fill and a mock of the template that should be filled.

On the template I have labelled the column that the data needs to be pulled from the source.

My actual source file has thousands of rows, hence I would like to try and automate this process.

http://s000.tinyupload.com/?file_id=23410729005099437480 - Template to be filled

http://s000.tinyupload.com/?file_id=65522839353028468870 - Source file

Really appreciate the help

 

[exoremmy]

additional info:

It needs to generate a new workbook for each row of data