U
username
I'm getting pretty desparate, so any help would be really gratefull
received.
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.
Each time a new sheet is created, I would also like to be able to:
1) copy a range in a summary worksheet and paste another version o
this directly beneath the original range. Repeat this as many times a
the user has created activity worksheets.
2) Pre-populate information within each of these ranges on the summar
sheet from each of the separate activity worksheets.
I guess also that the User may delete certain activity worksheets s
will not necessarily have sequentially numbered activities. However
the worksheets they spawn should all have the name format: Activit
(n).
Any help would be really fantastic
received.
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.
Each time a new sheet is created, I would also like to be able to:
1) copy a range in a summary worksheet and paste another version o
this directly beneath the original range. Repeat this as many times a
the user has created activity worksheets.
2) Pre-populate information within each of these ranges on the summar
sheet from each of the separate activity worksheets.
I guess also that the User may delete certain activity worksheets s
will not necessarily have sequentially numbered activities. However
the worksheets they spawn should all have the name format: Activit
(n).
Any help would be really fantastic