Hide/Unhide rows based on Yes or No answers to questions by dropdown list.

Hello All

I have a basic questionnaire with 10 questions in it. Under each questions there are some rows to use depending on the answer. Please see attached sample workbook.
Each question has to be answered by a drop-down list of Yes or No.

For example:

If the answer is "No" to Question 1, rows 4 to 11 remain hidden or re-hidden.
If the answer is "Yes" then rows 4 to 11 are revealed to give further details.

Next

Question 2 and if the answer is "No", row 14 to 21 remain hidden ...... and so on

Any help is appreciated.

Thanks

Mehmetcik

Thank you very much for your help. It works perfect as it is!

If I change the questionnaire with a mixture of different questions and do not keep the same pattern of distance and space for answers;
Can I specifically name the target range and rows to hide in the code?

For example after the question1, question 2 will have only two rows for the answer, question3 will have 3 rows and question 4 only one.

Once again thanks for your help (Teşekkür ederim=

Xladept

Thank you for your help too.

I just saw your reply now.

Xladept

Yes I understand.

Is there a way to name the target cells and then based on the cell value (Yes or No) a specified range of rows are hidden?

For example;

If "K12" is "No", then rows(14:20) hidden, if "Yes" visiable.
next
if "K22" is "No", then row(24:26) hidden (shorter range to hide here) and so on.

Thank you

Xladept

Working well.

Thank you

Mehmetcik

Excellent work, thank you very much for your time and effort.

Regards