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
Bookmarks