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

On Tue, 16 Mar 2010 09:13:01 -0700, Gringarlow
wrote:

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.