Creating multiple files from template with data pulled from an excel data base.

[ming113]

Hi all, am new to data entries and am trying to solve a problem using excel.

I am using office 365.

I have an excel database (database.xlsx) with data populating 6 columns (A-F). There's about 300 rows worth of data.

Am intending to create multiple files (300 unique documents) using an excel template. Where the data is pulled from the above database file.
Data from Col A will be used for the file name
Data from Col B will populate Cell B1 of each unique file
Data from Col C will populate Cell C1 of each unique file
Data from Col D will populate Cell D1 of each unique file
Data from Col E will populate Cell E1 of each unique file
Data from Col F will populate Cell F1 of each unique file

Anybody can help me out with this problem please?

thanks a lot!

 

[ming113]

Also, assuming the template file I am trying to use is named: template.xltx

 

[ming113]

Bumping the thread up