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

@ajh1999 

 

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.

 

NikolinoDE

I know I don't know anything (Socrates)