Hi,

I need some assistance is writing a macro (I think?) to hide rows based on cell(s) value.


I have 4 columns:

"Number"
"Name"
"Last Year $"
"This Year $"


If "Last Year $" and "This Year $" = $0, I want to be able to automatically hide the row. I am working with a spreadsheet that has over 200 rows of data.


I am also interested to know of a way to automatically unhide a row if the statement above is no longer true.


I do not have alot of experience with macros so any basic help is greatly appreciated. Thanks.