|Go to this site |
and scroll down to the 6th template:
DV0051 - Assign Players Each Inning
I use that template to build Softball Rosters. Once a name has been chosen from a drop down in any given inning, it is no longer available in the drop down for that inning.
Perhaps the techniques used in that template can be modified to work for you.
Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.