i need help with formula

[Guest]

I am trying to create a formula and need help. What I am trying to do is
create a formula for my fantasy football draft. What I want is for the first
box to be like a dropbox type thing where I can put QB, RB, etc.. from there
if I pick QB then I want to be able to pick from a list of QB's in the next
box. If anyone could help me I would appreciate it. It has been a while since
I have had a class on excel!

 

[Guest]

see:

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

 

[Guest]

Take a look here:

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

 

[Guest]

Thank you very much! It helped out and answered my question!

 

[Gord Dibben]

See Debra Dalgleish's site for how to create dependent Data Validation lists.

http://www.contextures.on.ca/xlDataVal02.html


Gord Dibben MS Excel MVP