Hiding Used items in Drop Down List across a whole worksheet

Occasional Visitor

I have a client who wants a work schedule and with a drop down list and if he selects a worker, his name doesn't come up in the drop down list in the rest of the column. 


I've worked out to do this for the first column however I want this to reset and start again on the next column etc.  Is there any way to do this?



1 Reply



Welcome to your Excel discussion space!


If you’re looking to ask a question or start a conversation about Excel, you’re in the right place!  Ask away.


Please include the following info to help others answer your question:

Click on upper Link for more Informations.


Thank you for your patience and time.



I know I don't know anything (Socrates)