| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
One Selection From Drop Down List Limits Remaining Selections
Hi
Have sheet that has a column of 10 empty cells (B2:B11), which each need a name put against the list of tasks (A2:A11). I want to make the names appear from a drop down box, but once i have selected one name for a task, i need to ensure that that particular name is not available for selection in the drop down boxes of the remaining cells. Does anyone know if this is possible? I want to avoid having to conditional format a load of hidden countifs to spot & highlight duplicates. Many thanks in advance, please let me know if there is anymore info you require. cheers jb |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Unique drop down list | Excel Worksheet Functions | |||
| re-ordering the list on a filter drop down | Excel Discussion (Misc queries) | |||
| Making pick list conditional on selection from previous pick list | Excel Discussion (Misc queries) | |||
| Drop list affected by previous choice | Excel Worksheet Functions | |||
| changing value of a cell by selecting an item from a drop down list | Excel Worksheet Functions | |||
Threaded Mode
