Hide/Unhide Rows in One Worksheet Based on Values in Cells in Another Worksheet

Hello,

Please see the attached workbook. What I am looking to do is when someone opens this workbook, they will start on the "Benefit Info" worksheet. They will look at the benefits available on the sheet, and then go down the list and put in a Y or N based on what benefits are needed.

What I would like to happen is that when changes are made on the "Benefit Info" worksheet, on the "Benefits at a Glance" worksheet certain rows become hidden. For example, if someone put down Y for Medical, nothing happens, but say they put down an N for GAP, then rows 25:40 on "Benefits at a Glance" are now hidden.

Conversely, if someone initially puts down a N on one of the options, but then changes it to a Y, then the rows will unhide.

The rows that will need to be hidden in the event of an N are below:

Medical - 4:24
GAP - 25:40
Critical Assistance - 41:50
Accident Advance - 51:65
Dental - 66:77
Vision - 78:86
Cancer Select - 87:100

Unfortunately I have 0 experience with macros/vba, so any help at all will be greatly appreciated.

Thank you.

You would use the worksheet_change event of the Benefit Info sheet. Place this code on the Benefit Info's code page:

Please Login or Register  to view this content.