Hello, I am trying to create a questionnaire in excel whereby you would select an answer from a dropdown list and depending on what it is e.g. “Yes”, it would unhide the row below so that another question could be asked.
I’ve searched through a few threads and I think I would have to use a macro for that (which I can’t work out how to do!) and any that I have come across tend to want to hide cells instead of unhide them.
I have listed my requirements below. If anyone could help me out it would be greatly appreciated!!!!! Thank you ??
I’ve searched through a few threads and I think I would have to use a macro for that (which I can’t work out how to do!) and any that I have come across tend to want to hide cells instead of unhide them.
I have listed my requirements below. If anyone could help me out it would be greatly appreciated!!!!! Thank you ??
If E13 = "Yes - optional additional benefits" then unhide row 14 |
If E13 = "Yes - this product is an add-on" then unhide row 15 |
If E13 = "Yes - this is a packaged policy" then unhide row 15 |
If E16 = "Yes" then unhide row 17 |
If E18 = "Yes" then unhide row 19 |
If E22 = "Yes" then unhide rows 23:25 |
If E25 = "Yes" then unhide row 26 |
If E27 = "Yes" then unhide rows 28:32 |
If E34 = "Yes" then unhide rows 35:36 |
If E38 = "Yes" then unhide row 39 |
If E40 = "Yes" then unhide row 41 |
If E42 = "Yes" then unhide row 43 |
If E44 = "Yes" then unhide row 45 |
If E46 = "Yes" then unhide row 47 |
If E48 = "Yes" then unhide row 49 |
If E54 = "Yes" then unhide row 55 |
If E76 = "No" then unhide row 77 |