Creating mutiple workbooks from a template with different headers

You would format your TEMPLATE sheet with the large font you want in cell A1 before you started making copies of it and putting data into it. That's the point of a template, to have all the design and formatting done for you already.



'FILL OUT A TEMPLATE FROM A DATABASE
I have a macro for taking the data from a database sheet and filling out a template sheet over and over again with the data.

Data Into Template

The macro fills out the template and saves each one as a separate file OR creates a separate sheet, your choice. That last part can be tweaked to do other things, this is mainly to demonstrate a simple way to fill out a form from a row-based database.

I am terrible with macros and I am trying to tweak the one you linked. I think I just to to tweak the bottom section. I have my list of headers in column A of the main sheet and each header needs to go into cell A1 of the workbooks created from the template. It would be nice to save each workbook so its name matches the headers in cell A1. Any more help is greatly appreciated.

Determine last cell of data then loop through the cells one at a time

Please Login or Register  to view this content.

I was able to figure it out. I modified the bottom section of the link JBeaucaire provided. The changes are below. Also I needed the headers from the main sheet to actually go into cell A2 of the workbooks created.

'Determine last cell of data then loop through the cells one at a time

Please Login or Register  to view this content.

THANKS AGAIN FOR THE HELP!

Good job, you discovered the meaning and method of "'edit these rows to fill out your form, add more as needed"...

See ya next time.