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,IF(D3=K16,Camino,IF(D3=K17,Admin,IF(D3=K18,Arroyo,IF(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
Bookmarks