You're welcome! Thanks for letting me know that it helped.

Noel wrote:
Thank you, that seems to be working great

"Debra Dalgleish" wrote:


There are instructions here for creating dependent data validation lists:

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

Noel wrote:

I am trying to create a form that contains conditional drop down lists for
the user to selct from. i want the user to be able when theypick from a list
i created in cell D3 and when they choose that i want a list to be created in
cell E3 which contains data from a second worksheet. I was able to make it
work using nested if statements for validation but the problem is that it
wont let me go past 7 and i need to do about 50 of them. To make things
easier i defined names to reference all the data on the second worksheet.
This is what i used and it would work if i could do about 50 of them
=IF(D3=K13,Roc,IF(D3=K14,Roc,IF(D3=K15,Camino,I F(D3=K16,Camino,IF(D3=K17,Admin,IF(D3=K18,Arroyo,I F(D3=K19,Atascadero,IF(D3=K20,Grover))))))))
matching the cell D3 to data i used to create the list really just matching
itself to itself.
I know there has to be some simple VB code to make it work or some simple
solution, and i do have some experience using vb code but not in this kind of
enviroment.
Does Anyone have any ideas?

--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html