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!!!
Bookmarks