Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Limit Drop Down Menu Options Among Cells
I have a drop down menu set up on a number of cells in one column. Problem
is, I want to be able to make a selection within that column only once. Basically, as an item is chosen from the menu, it should no longer be available in subsequent cells within the same column. Is this possible?? -- BP |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Limit Drop Down Menu Options Among Cells
Believe Debra has just the recipe at this oven#:
http://www.contextures.com/xlDataVal03.html -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- "BP" wrote: I have a drop down menu set up on a number of cells in one column. Problem is, I want to be able to make a selection within that column only once. Basically, as an item is chosen from the menu, it should no longer be available in subsequent cells within the same column. Is this possible?? -- BP |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Displaying Drop-Down Menu Options | Excel Discussion (Misc queries) | |||
SAVE and SAVE AS options disappeared from the drop down FILE menu | Excel Discussion (Misc queries) | |||
how do i choose multiple options in a drop down menu in excel? | Excel Discussion (Misc queries) | |||
Drop-down menu options | Excel Discussion (Misc queries) | |||
How do I increase the font of my drop-down menu options? | Excel Worksheet Functions |