Hi again all,

there seem to be plenty of posts regarding this topic around here, but
I can't find exactly what I need, if its possible at all.

What we have is a template that gets filled out each time, then not
normally saved afterward though we could probably change that part of
the routine. What I need, is some information like client's names etc
to be saved in a second sheet after the template has been used.
Normally that template is used over and over again and each time
cleared, then the information manually written out again in the second
report sheet.

Is there a possible way that after the template has been used, to get
the second sheet to take a record of this information, the template
cleared again and that information still kept in the report?

Thanks for any help