Drop down list with blocks

%3CLINGO-SUB%20id%3D%22lingo-sub-2297251%22%20slang%3D%22en-US%22%3EDrop%20down%20list%20with%20blocks%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2297251%22%20slang%3D%22en-US%22%3E%3CP%3EHi%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EFirst%20time%20i%20have%20used%20this%2C%20and%20not%20sure%20what%20i%20need%20can%20actually%20be%20done%2C%20but%20any%20help%20would%20be%20great.%20Not%20very%20knowledgeable%20on%20Excel%20so%20please%20be%20kind%20if%20you%20reply%20%3A-).%20I%20need%20a%20drop%20down%20list%20in%20a%20cell%2C%20say%2012%20items%2C%20but%20once%20an%20item%20is%20picked%20i%20need%20this%20to%20no%20longer%20be%20available%20to%20the%20next%20person%20(so%20blocking%20each%20one)%20until%20they%20are%20all%20used%20up.%26nbsp%3B%20Then%20if%20some%20one%20unpicks%20it%2C%20it%20becomes%20free%20again.%26nbsp%3B%20Is%20this%20possible%3F%20thanks%26nbsp%3B%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2297251%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2297638%22%20slang%3D%22en-US%22%3ERe%3A%20Drop%20down%20list%20with%20blocks%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2297638%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1038042%22%20target%3D%22_blank%22%3E%40MichelleH1574%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3ESee%20%3CA%20href%3D%22https%3A%2F%2Fwww.contextures.com%2FxlDataVal03.html%22%20target%3D%22_blank%22%20rel%3D%22noopener%20nofollow%20noreferrer%22%3EHide%20Used%20Items%20in%20Drop%20Down%20List%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EIt%20contains%20multiple%20detailed%20examples%2C%20and%20a%20list%20of%20freely%20downloadable%20sample%20workbooks.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Visitor

Hi

 

First time i have used this, and not sure what i need can actually be done, but any help would be great. Not very knowledgeable on Excel so please be kind if you reply :-). I need a drop down list in a cell, say 12 items, but once an item is picked i need this to no longer be available to the next person (so blocking each one) until they are all used up.  Then if some one unpicks it, it becomes free again.  Is this possible? thanks  

1 Reply

@MichelleH1574 

See Hide Used Items in Drop Down List 

It contains multiple detailed examples, and a list of freely downloadable sample workbooks.