Data Validation

[riderfan]

I'm trying to use excel for use in a golf draft. What I want to do i
use data validation to form a drop down list where people pick thie
golfers. You have to pick four different golfers out of a group o
eight. But what I want to do is not have the golfers already picke
show up on the list of the 2nd ,3rd and 4th golfers. So if you pic
Tiger Woods first he does not show up again on the list when you mak
your second pick, and so on. Does anyone have any solutions. thank
very much. jory Dimon

 

[JulieD]

Hi

Check out Debra Dalgleish's website for details on how to do this ...
http://www.contextures.com/xlDataVal03.html

Cheers
JulieD

 

[Debra Dalgleish]

There are instructions on the following page that you should be able to
adapt to your worksheet:

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