Drop down list conect to scecific rows

[mmue]

hello everyone,

I have on Problem, namely i have excel sheet with some questions, these question could be divided in 2 parts, which I can choose from dropdown list. How could I arrange, that when i choose e.g. part 1 from dwrop down, only questions reffering to part one are displayed???


please advice
thank you in advance

 

[VoG]

This should help you http://www.contextures.com/xlDataVal02.html

 

[mmue]

Thank you for the link, but it is different.

when i choose e.g from drop down list color, sammple questions reffering the color schoud appear, and if i choose fruit, questions to fruit schould appear... like form

regards