Data Vaildation

[cole7011]

is there a way of having a data validation list that’s dependant on the users choice of another,


to elaborate

cell B3 is a data validation list, with the following contents, A, B, C etc

When A is selected, from that drop down list, C3 should display another list, with the following contents 1,2,3 etc,

However if B was chosen from the list in B3 then another list would ne displayed with the following contents Q,W,E, etc

thanks

 

[Tazguy37]

Have a look at this thread: http://www.mrexcel.com/board2/viewtopic.php?t=110566

Also has another link in it, check that out too! Hope that helps!

 

[Smitty]

See Aladin's comments on Dependent Lists.

HTH,

Smitty

 

[cole7011]

great, but what about adding a third one on.... ?

 

[Von Pookie]

Continued here:
http://www.mrexcel.com/board2/viewtopic.php?t=126785