Dropdown list that updates

[scohut]

All,

I have drop down lists that I use to assign the employees at work to complete certain daily tasks. I am wondering if there is a way for the list to update and eliminate the items I have already assigned from the dropdown menu so that I can see only the tasks not assigned as I progress through the list of employees. Or if there is a better way/technique that would produce these results. I.e. when I get to employee 40 the dropdown list next to their name only displays the remaining tasks not yet assigned.

Thanks for the help.

 

[jbeaucaire]

I have a sheet to demonstrate a technique I use for this:

Diminishing Drop Down Lists​

 

[scohut]

Thanks

 

[lenze]

Also, see
http://www.contextures.com/xlDataVal03.html

lenze