I have a button which allows the user to create templated worksheets
each time they press it. These worksheets 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. Currently my macro
expects there to be as many activity worksheets as I created during the
macro recording (rather than the custom # that a user may have).

I guess also that the User may delete certain worksheets so will not
necessarily have sequentially numbered activities. However, the
worksheets they create should all be in the format: Activity (n).

Any ideas? Many thanks.


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