I am trying to separate data from my name list into groups according to the age of the participant. I want to be able to upload my list and the data separate on the appropriate sheet automatically.
For example I have:First Name Last Name AGE
Mitchell Zumbrunn 12.1
Brennan Vignati 10.3
Riley Vignati 8.0
Deja Tregre 6.5
Jordan Thompson 10.2
Liam Thompson 9.2
Marquise Thomas 13.1
Klesi Stubbs 7.5
Codey Strickland 13.9
on one sheet and the counselors' names on the other sheet. I would like to separate them out by age group with each counselor each time I upload a new list automatically. I can sort them by age but then I still have to copy and paste the names into the roster file. This would be fine if it weren't a ton of names (over 70).
If you would like an edited copy of the file (for privacy reasons) I can send it to you. Please help me. Thank you!
Jeff Y
Bookmarks