U
username
I have a button which allows the user to create templated worksheet
each time they press it. These worksheets have a series of fields tha
relate to 'activities'. The user can chose to spawn worksheets for on
or more activities.
I would like a summary sheet to add all the activity information fro
as many activity worksheets as the user has created. Currently my macr
expects there to be as many activity worksheets as I created during th
macro recording (rather than the custom # that a user may have).
I guess also that the User may delete certain worksheets so will no
necessarily have sequentially numbered activities. However, th
worksheets they create should all be in the format: Activity (n).
Any ideas? Many thanks
each time they press it. These worksheets have a series of fields tha
relate to 'activities'. The user can chose to spawn worksheets for on
or more activities.
I would like a summary sheet to add all the activity information fro
as many activity worksheets as the user has created. Currently my macr
expects there to be as many activity worksheets as I created during th
macro recording (rather than the custom # that a user may have).
I guess also that the User may delete certain worksheets so will no
necessarily have sequentially numbered activities. However, th
worksheets they create should all be in the format: Activity (n).
Any ideas? Many thanks