SpencerRichman
New Member
- Joined
- Feb 15, 2013
- Messages
- 33
- Office Version
- 2021
- Platform
- Windows
Hi all. I am creating a scorecard for a rock climbing competition. When the team turns in their scorecard, I want the staff to be able to enter the team # and then click radio buttons to indicate how each climber did on each route. It would look like this:
I would like the radio buttons in row 7 (and when complete, I'd have radio buttons in all rows) to link to cells for Mary Kay's row on another sheet. BUT, when the staff member changes the team # in cell B2, a different competitor's name will appear in cell D4, and then I'd like the radio buttons in row 7 link to DIFFERENT cells on another sheet.
Does anyone know how to accomplish this?
I would like the radio buttons in row 7 (and when complete, I'd have radio buttons in all rows) to link to cells for Mary Kay's row on another sheet. BUT, when the staff member changes the team # in cell B2, a different competitor's name will appear in cell D4, and then I'd like the radio buttons in row 7 link to DIFFERENT cells on another sheet.
Does anyone know how to accomplish this?