Auto-hide/show Rows based on Yes/No Criteria

Hi all,

As stated in title, I would like to auto-hide/show certain rows based on Yes/No criteria which is selected by user via list. I know this cannot be completed with a formula but can be done so easily with a macro.

There are many macros online that people have posted, but with absolutely 0 macro experience I was hoping for a bit more specific help. Attached is a spreadsheet with the format intended. User selects Yes or No in column C "Answer" column and as a result, it auto-hides/shows the rows in the table below it (Rows 19-46). I have also included in column E the specific rows to be hidden/shown based on user selection. If user selects "No", it should hide the rows. If "Yes", show the row.

If you could provide some macro guidance and how i can implement this into the spreadsheet i would greatly appreciate it.

Thanks in advance for your help - you guys have always come through for me.

Jake

MacroHelpPlease.xlsx

Thanks for the response - where does it designate which specific Rows are hidden?

See if this does what you require.

Awesome John - works perfect!

Quick question, how do I view the macro? I would like to see the logic for my own reference. When i press view Macros nothing appears in list?

Glad it works for you. Right click on the Sheet Tab and select View Code.