Creating a new worksheet from a template
 

I would like to press a button on one worksheet and create a new
worksheet that conforms to a template.

However:
1) this is for a series of people who do not work centrally and who are
not technical i.e. the solution needs to be self-contained within my
workbook and not involve the creation of xlst templates that have to
sit in a certain place on the hard drive.

2) These worksheets will have a series of fields that relate to
'activities'. The user can chose to spawn worksheets for one or more
activities. I would like a summary sheet to add all the activity
information from as many activity worksheets as the user has created.
If I do this from a macro the macro expects there to be as many
activity worksheets as I have created during the macro recording
(rather than the custom # that a user may have). Any ideas?

3) If I want to reset this Summary sheet - is there a better way than
hiding an empty Summary sheet on the same worksheet and copying and
pasting over the full Summary sheet using a macro button?

Many thanks all...


--
username
------------------------------------------------------------------------
username's Profile: http://www.msusenet.com/member.php?userid=1433
View this thread: http://www.msusenet.com/t-1870443684