VBA to hide rows with zero value

[kneee]

Hello,

I have a spreadsheet with multiple columns, where I created an IF statement to add the total values in the relevant cells and if the total = zero, I return the phrase "hide" These become the rows I want to hide until we updated values next period.

This is for a department level P&L, unique tab for each, I will reset the data each month.

Appreciate any help / insight.

 

[Joe4]

VBA shouldn't be necessary. This can be done pretty simply using Filters.