View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
lilralph lilralph is offline
external usenet poster
 
Posts: 1
Default validation help with drop down


Thanks in advance
I have been assigned to design our Fire Department montly schedule.
have a template that we currently use. It use validation to make a dro
down list of employees to choose from. It works great but has room fo
human error such as selecting same person twice.
Now to the question is there a way when selected name is used it wil
not appear on list.

Once again thanks
Ralp

+-------------------------------------------------------------------
|Filename: ACREW.zip
|Download: http://www.excelforum.com/attachment.php?postid=4187
+-------------------------------------------------------------------

--
lilralp
-----------------------------------------------------------------------
lilralph's Profile: http://www.excelforum.com/member.php...fo&userid=2994
View this thread: http://www.excelforum.com/showthread.php?threadid=49839