I am faced with a situation where I need the option to hide many rows with a button. I am unsure how to write the code to trigger a macro that would scan a column and depending on the value detected in each row, that row would be hidden.
IE: it scans Column D for a check-mark or dash. If Row 2 is a dash it is hidden, however if Row 3 is a check mark, it is not.
Additionally, I am not clear on how to create a button that would activate this macro, although I'm sure it is the easy part.
I have attached a dummy workbook for reference to clarify what I am asking help for.
Any help would be greatly appreciated!
Thank you
Bookmarks