Macro to automatically hide or unhide rows based on either a value or no value in a cell

[WFP111]

I have researched the forum, however, I could not find a solution that properly addresses this request.

I have an estimate spreadsheet that has many data entry sheets and a Summary Sheet.
The summary sheet auto-populates based on data entered into other sheets.
There is no work performed on the summary sheet.


I would like specific rows on the Summary Sheet to be hidden unless there is an actual value greater than "0".
All rows that contain a value in Column H, will UNHIDE atomatically, based on having a value greater than "0".
If an existing was previously shown to have a value and then updated to reflect a "0" value or "Blank" value, then it should be hidden again automatically.

I have attached a sample for reference.

[Fotis1991]

Perhaps something like this?

Please Login or Register  to view this content.

[Solus Rankin]

Will there be any chance of a negative value?

Perhaps using an Absolute of the Range.Value would help to capture those.

[WFP111]

Will there be any chance of a negative value?

Perhaps using an Absolute of the Range.Value would help to capture those.

Thanks Solus,
in this application, there are no negative values, as I will be entering only costs associated with proposed construction. However, I could possibly use the absolute value suggestion for another application.

[Fotis1991]

What's about post#2?

[WFP111]

Thanks Fotis.
This works great as intended.
Since I am a novice with macros, is it possible to make this run continuously or at every "save"? Therefore, I would not have to create a toggle or pull the macro from a list to run the program.

[Fotis1991]

I think it's better to run every time that you open your workbook.

Please Login or Register  to view this content.

[WFP111]

Fotis 1991,
Thanks for your suggestion.