Drop-down (with validation) relate to content of multiple other drop-down menues

[JCK11]

Hi All

I hope one of you can help me with the following.

I have in principle the following situation:

drop-down cell 01(med with validation): option01-option12


if this shows for example "option01"

I did like drop-down cell 02 to show only: option01
and
I did like drop-down cell 03 to show only: option04-08
and
I did like drop-down cell 04 to show only: option04

So my question is if one of you could help me at bit on the way how to set up the equation so that drop-down menu 02, 03 and 04 only show a certain range of the menu depending on what is shown in drop-down cell 01?


Any help is very much appreciated and sorry if the terms are not correct, but I am still relatively new to this...


Thanks in advance...