U
username
I would like to press a button on one worksheet and create a ne
worksheet that conforms to a template.
However:
1) this is for a series of people who do not work centrally and who ar
not technical i.e. the solution needs to be self-contained within m
workbook and not involve the creation of xlst templates that have t
sit in a certain place on the hard drive.
2) These worksheets will have a series of fields that relate t
'activities'. The user can chose to spawn worksheets for one or mor
activities. I would like a summary sheet to add all the activit
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 man
activity worksheets as I have created during the macro recordin
(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 tha
hiding an empty Summary sheet on the same worksheet and copying an
pasting over the full Summary sheet using a macro button?
Many thanks all..
worksheet that conforms to a template.
However:
1) this is for a series of people who do not work centrally and who ar
not technical i.e. the solution needs to be self-contained within m
workbook and not involve the creation of xlst templates that have t
sit in a certain place on the hard drive.
2) These worksheets will have a series of fields that relate t
'activities'. The user can chose to spawn worksheets for one or mor
activities. I would like a summary sheet to add all the activit
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 man
activity worksheets as I have created during the macro recordin
(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 tha
hiding an empty Summary sheet on the same worksheet and copying an
pasting over the full Summary sheet using a macro button?
Many thanks all..