Hiding Used items in Drop Down List across a whole worksheet

[ajh1999]

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?

[#2]

@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)