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

Once again thanks
Ralph


--
lilralph
------------------------------------------------------------------------
lilralph's Profile: http://www.excelforum.com/member.php...o&userid=29949
View this thread: http://www.excelforum.com/showthread...hreadid=496459

See http://www.contextures.com/xlDataVal03.html

--

HTH

RP
(remove nothere from the email address if mailing direct)


"lilralph" wrote in
message ...

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

Once again thanks
Ralph


--
lilralph
------------------------------------------------------------------------
lilralph's Profile:
http://www.excelforum.com/member.php...o&userid=29949
View this thread: http://www.excelforum.com/showthread...hreadid=496459

Thanks Bob I was wondering if this is a link to your site? I checked it
out and it worked on single day but need it to work on 10 day schedule
for our firedeparment which consist of 30 employees on my shift.
If this is not your work I will see if the site manager can help. Still
a little lost.


--
lilralph
------------------------------------------------------------------------
lilralph's Profile: http://www.excelforum.com/member.php...o&userid=29949
View this thread: http://www.excelforum.com/showthread...hreadid=496459

No it is not my site, but I know the technique well as use a modified
version of it myself.

Do you mean that you want to allocate A& B on day 1 say, and then on day 2
A&B will be excluded from the list of available people? IF so, I would have
thought that the technique would do that?

--

HTH

RP
(remove nothere from the email address if mailing direct)


"lilralph" wrote in
message ...

Thanks Bob I was wondering if this is a link to your site? I checked it
out and it worked on single day but need it to work on 10 day schedule
for our firedeparment which consist of 30 employees on my shift.
If this is not your work I will see if the site manager can help. Still
a little lost.


--
lilralph
------------------------------------------------------------------------
lilralph's Profile:
http://www.excelforum.com/member.php...o&userid=29949
View this thread: http://www.excelforum.com/showthread...hreadid=496459

Thanks again Bob.
Possible you can fill out the formula for me. I need to have a separate
but same list for each day. If you can help please let me know. Also I
would love to know what I am missing.
Thanks
Attached template for Fire Department


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

--
lilralph
------------------------------------------------------------------------
lilralph's Profile: http://www.excelforum.com/member.php...o&userid=29949
View this thread: http://www.excelforum.com/showthread...hreadid=496459

I would need more info to complete this. What is STA. 35, 26 etc.? Where
would the DVs be, and where would the next be after a selection? Where does
Leave and Training come into it?

--

HTH

RP
(remove nothere from the email address if mailing direct)


"lilralph" wrote in
message ...

Thanks again Bob.
Possible you can fill out the formula for me. I need to have a separate
but same list for each day. If you can help please let me know. Also I
would love to know what I am missing.
Thanks
Attached template for Fire Department


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

--
lilralph
------------------------------------------------------------------------
lilralph's Profile:
http://www.excelforum.com/member.php...o&userid=29949
View this thread: http://www.excelforum.com/showthread...hreadid=496459