software

HiHave 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 amp; highlight duplicates.

Many thanks in advance, please let me know if there is anymore info you
require.cheersjb

See www.contextures.com/xlDataVal03.html

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

quot;JB2010quot; gt; wrote in message
...
gt; Hi
gt;
gt;
gt; Have sheet that has a column of 10 empty cells (B2:B11), which each need a
gt; name put against the list of tasks (A2:A11). I want to make the names
appear
gt; from a drop down box, but once i have selected one name for a task, i need
to
gt; ensure that that particular name is not available for selection in the
drop
gt; down boxes of the remaining cells.
gt;
gt; Does anyone know if this is possible? I want to avoid having to
conditional
gt; format a load of hidden countifs to spot amp; highlight duplicates.
gt;
gt; Many thanks in advance, please let me know if there is anymore info you
gt; require.
gt;
gt;
gt; cheers
gt;
gt;
gt; jb

Try this example in the attached zipped file -------------------------------------------------------------------
|Filename: example.zip |
|Download: www.excelforum.com/attachment.php?postid=4425 |
-------------------------------------------------------------------

--
Gary Brown
------------------------------------------------------------------------
Gary Brown's Profile: www.excelforum.com/member.php...oamp;userid=17084
View this thread: www.excelforum.com/showthread...hreadid=519665