Excel list validation question

[sdeelkali]

Guys,

I have a question.
I know how to validate a list in excel but my problem is to validate a second list.

For example when you make a choice for "separated" in the first list.
I want the next option make it possible to have two lists.
In cell B1 should be chosen from 'a' or 'b'
and in cell B2 needs to be choosen 'infiltratie' of 'relinen'
following the next steps are made in C1 and C2 are unhook from each other.

Is this only possible in VBA?

Hope you experts can help me!

Many thanks.


sdeelkali

 

[VoG]

Perhaps you mean dependent lists http://www.contextures.com/xlDataVal02.html

 

[sdeelkali]

Not really,

I meant, when you choose A in the fist list you only have the option in list B1.
But when you choose B in list 1 you have the fill in two list in B1 and B2.
Hope you understand what i'm talking about.
Try my best to explain it in English