MODERATOR NOTICE: This topic has also been posted on other sites and may already have an answer elsewhere. Please take this into consideration when answering this question
Hi everyone, I want to make a dependent drop down list but I want to add to it also the ability to hide the used items.
I will explain it a little bit:
I have a list of workers and some workers can work only with some workers.
DAVID FRED TINA SAM
Jhon Toni Jhon Tina
Sam Tina Anna David
So I want that if I will choose David in the cell under it I will see in the drop down only the bames that related to him (jhon and sam)
But I want that if I used David I then will not see his name, I dont want to see his name even if I will choose someone that can work with him (like sam for example) but since I used david his name should be removed from the drop down list.
I saw how can I make the hide used items and how to make dependent list but I cant find a way to join them together
Thanks for the help