Hiding Used items in Drop Down List across a whole worksheet

%3CLINGO-SUB%20id%3D%22lingo-sub-2751757%22%20slang%3D%22en-US%22%3EHiding%20Used%20items%20in%20Drop%20Down%20List%20across%20a%20whole%20worksheet%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2751757%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20a%20client%20who%20wants%20a%20work%20schedule%20and%20with%20a%20drop%20down%20list%20and%20if%20he%20selects%20a%20worker%2C%20his%20name%20doesn't%20come%20up%20in%20the%20drop%20down%20list%20in%20the%20rest%20of%20the%20column.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI've%20worked%20out%20to%20do%20this%20for%20the%20first%20column%20however%20I%20want%20this%20to%20reset%20and%20start%20again%20on%20the%20next%20column%20etc.%26nbsp%3B%20Is%20there%20any%20way%20to%20do%20this%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2751757%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
New Contributor

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)