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