Event Registration Form

Hello,

I am wondering how to go about getting data to auto populate from sheet1 to multiple sheets if a check mark is in use. I am trying to learn as I go, instead of doing it for me, if you are able to guide me on how to do this with the coding for future use.

Screenshot 2023-07-31 at 10.19.00 AM.png

For example here is a screenshot of part of the form I created. I would like to enter the athletes name, select if they are M or F and Jr or Sr athlete, then have their name be put in separated sheets if they are selected for whichever event. Or be able to deselect their name and their name will be taken off of the selected sheet if they aren't able to make it to the event. This event I'm coordinating with is separated from Jr and Sr athletes, so each event will have four sheets per event except the Arm Pull and One Hand Reach. Meaning there will be a Jr Male, Jr Female, Sr Male and Sr Female Scissor Broad Jump.

I appreciate the guidance for this process and have a good day.

Hello,

start using a filter or an advanced filter …