I know similar questions have been asked, but I can't adapt them to my problem.
I want a sheet macro (auto updating) to hide rows when a cell value in that same row changes to 0. For instance, row 3 must be hidden (and unhidden) when value in C3 changes.
The cells with zero/non-zero changes based on rather simple if formulas that are based on changes in a particular cell in another sheet in the same workbook. That last information is probably not relevant, because I want the sheet to auto-update based on a simple zero - non zero logic.
I want a sheet macro (auto updating) to hide rows when a cell value in that same row changes to 0. For instance, row 3 must be hidden (and unhidden) when value in C3 changes.
The cells with zero/non-zero changes based on rather simple if formulas that are based on changes in a particular cell in another sheet in the same workbook. That last information is probably not relevant, because I want the sheet to auto-update based on a simple zero - non zero logic.
