Drop down selection and populating data

Suray1911

New member
Joined
Sep 29, 2015
Messages
2
Reaction score
0
Points
0
I have a sheet I'm working on that has 32 teams .. there are 2 teams per cell totaling to 16 cells..
B C
(team1/team2) (team3/team4)
5. Team1. Team3
6. Team2. <Drop downs.> Team4
drop down gives ppl option to pick team 1 or team 2..
Out of those 16 cells (picks) I need to cap them to 9. Once nine teams have been selected, a message will pop up imforming them of max picks.
Once they've made their picks. I need those picks to be listed automatically somewhere on the sheet in vertical format.

________
________
________ etc..
Any help is appreciated..
 
Last edited:
View photo for further layout..
 

Attachments

  • Screenshot_2015-09-27-17-30-30-1.jpg
    Screenshot_2015-09-27-17-30-30-1.jpg
    92.8 KB · Views: 8
Back
Top