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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
One Selection From Drop Down List Limits Remaining Selections
See http://www.contextures.com/xlDataVal03.html
-- HTH Bob Phillips (remove nothere from email address if mailing direct) "JB2010" wrote in message ... 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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
One Selection From Drop Down List Limits Remaining Selections
Try this example in the attached zipped file +-------------------------------------------------------------------+ |Filename: example.zip | |Download: http://www.excelforum.com/attachment.php?postid=4425 | +-------------------------------------------------------------------+ -- Gary Brown ------------------------------------------------------------------------ Gary Brown's Profile: http://www.excelforum.com/member.php...o&userid=17084 View this thread: http://www.excelforum.com/showthread...hreadid=519665 |
Reply |
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 |