Remove Used Items in Excel Drop Down
There is a new sample file on my Contextures web site, which lets you pick players for each inning in a baseball game. You could tweak the file a bit, and use it to assign employees to workstations each day of the week, or anything similar.
Once you have assigned a player in an inning, that name disappears from the drop down list in that column. In the screen shot below, Mike has been assigned as the pitcher for inning one. When I open the list in the cell below, Mike’s name is missing – it used to be between Lee and Pat.
See the Assignments by Player Name
There was an older version of this sample file, and I have updated it to use Excel Tables. I’ve also added a sheet that shows the assignments by player name, and you can see how often each player was assigned to a position.
Download the File
To see the file, and how it works, you can download it from my Contextures website. On the Excel Samples page, look for DV0061 – Assign Players Each Inning. The file is in xlsx format, and does not contain macros.