SpencerRichman
New Member
- Joined
- Feb 15, 2013
- Messages
- 33
- Office Version
- 2021
- Platform
- Windows
I am creating a scorecard for a climbing competition that looks like this:
Note - there's actually 3 weeks horizontally and 2 climbers vertically, so 6x this amount of option buttons on the scorecard, but I only show one here to keep the picture size small.
It took a lot of work to set the option button groups for all 144 buttons on this worksheet. And this worksheet would be the scorecard for one team consisting of 2 climbers. Now I have to replicate this for all the teams. I was hoping to just have a separate worksheet tab in this one workbook for all the teams. But when I "Create a copy" of this worksheet, the option button groups on the new worksheet are still 'tied' to the option button groups on the original worksheet. Is there any way for me to replicate this page without having to re-do the properties of every option button group, and without simply having a different entire workbook for each team?
Note - there's actually 3 weeks horizontally and 2 climbers vertically, so 6x this amount of option buttons on the scorecard, but I only show one here to keep the picture size small.
It took a lot of work to set the option button groups for all 144 buttons on this worksheet. And this worksheet would be the scorecard for one team consisting of 2 climbers. Now I have to replicate this for all the teams. I was hoping to just have a separate worksheet tab in this one workbook for all the teams. But when I "Create a copy" of this worksheet, the option button groups on the new worksheet are still 'tied' to the option button groups on the original worksheet. Is there any way for me to replicate this page without having to re-do the properties of every option button group, and without simply having a different entire workbook for each team?