Help hiding/unhiding rows based on multiple responses

I know very little about VBA/macros and would love some help!

I have 2 sheets in a workbook: summary and detail. There are 4 questions on the summary page with answers that are limited to a list of YES, NO, and - (for question 1) N/A (for questions 2-4). Based on the answer to each question, I would like rows on the detail tab to hide/unhide.


When Question 1 is answered -, I want rows 8:128 on sheet 2 hidden; answered YES, rows listed in C17:C23 unhidden; answered NO, do nothing.
Then when #2 is answered, unhide rows based on the lists in columns D and E.
#3, unhide rows based on the lists in F &G.
#4, unhide rows based on the lists in H &I.

In all cases, if the answer is N/A-do nothing.

I would prefer that this not run automatically. Maybe a button that can be activated when all questions have been answered? Also, if an answer is changed, I'll need the rows that were unhidden based on the previous answer to hide before unhiding according to the new answer.

Any help is greatly appreciated!!!

hi mglitter1, welcome to Excelforum, option if I understood your request correctly

The button is hidden until at least one answer has no entered answer

Hi watersev,
Thank you! This does exactly what I was hoping for. I had to make a few small changes to the row ranges for C6 but this code is so much more simplistic than anything I was trying to accomplish with my own limited knowledge.

You're the best! Thanks again.