I'm working on.. I need help capping the drop down selections to only 9 picks. Once 9 has been reached, user will have to deselect one to pick another.
Also, I would like to have the picks automatically populate to a list in vertical order just below the counter.

Any assistance with formulas etc would be greatly appreciated.



Ex.1
Column b. Column C
Row 5: Team1/team2. Team3/team4
------------------------ ------------------------
Team 1. Team 3
Drop downs > Team 2. Team 4

32 teams (16 cells w team vs team(team1/team2))
Once user has selected 9 teams . .. the picks need to automatically shoot down to a list a few rows down

Row 10 : Pick1 _________
Pick2. ________
Etc..

I do not have the ability to add an attachment..

Per email if needed
Su_ray85@outlook.com

Thanks In advance