Auto Populate a Template

[Gringarlow]

I know very little about VBA and the only way I have created Macros is by
having Excel follow my mouse and Recording the Macro, then modifying the
reults as needed.
Here is what I've been asked to do:
I have a spread sheet with several columns of data in various formats.
Each time a row of data is added, that data needs to be copied onto a
Template that is on another tab in the workbook.
Each time a new row of data is added, a new Template is to be created. The
old Templates must remain as they were.
So if I have 10 Rows of data, I should have 10 unique Templates.

 

[Gord Dibben]

What, in this context, is a Template on another tab in the workbook?

Templates are usually workbooks saved as a Template filetype.

Does not sound like you want that to happen.


Gord Dibben MS Excel MVP

 

[Gringarlow]

The Template I'm referring to is a Excel Worksheet formatted to look like a
Form.

 

[Gord Dibben]

You stated "data needs to be copied onto a Template that is on another tab
in the workbook"

Did you mean the "Template" is nothing more than a formatted worksheet
within the workbook?

You want one of these formatted worksheets for every row of data you add to
a Master input sheet?

You would have to have a blank formatted sheet that can be copied for each
row of data to be entered in Master input sheet.

Is that correct?

So let's design and format a worksheet then add code to copy a row from
Master input sheet, copy the blank "template" sheet and paste data into that
sheet.

Keep doing this until we run out of rows on Master input sheet?

What will we name the 10 "template" worksheets we added?

If you want to continue this off-line please email me a copy of the workbook
with some instructions on where to copy the data.

gorddibbATshawDOTca change the obvious.


Gord

 

[Gringarlow]

Ok, What is your e-mail address?

You stated "data needs to be copied onto a Template that is on another tab
in the workbook"

Did you mean the "Template" is nothing more than a formatted worksheet
within the workbook?

You want one of these formatted worksheets for every row of data you add to
a Master input sheet?

You would have to have a blank formatted sheet that can be copied for each
row of data to be entered in Master input sheet.

Is that correct?

So let's design and format a worksheet then add code to copy a row from
Master input sheet, copy the blank "template" sheet and paste data into that
sheet.

Keep doing this until we run out of rows on Master input sheet?

What will we name the 10 "template" worksheets we added?

If you want to continue this off-line please email me a copy of the workbook
with some instructions on where to copy the data.

gorddibbATshawDOTca change the obvious.


Gord






.

 

[Gord Dibben]

As posted at bottom of my reply.


gorddibbATshawDOTca change the obvious.


Gord