Hide rows based on cell value

Hello,

Pls advice: I have a worksheet which has many formulas and I need the following to happen: when this worksheet is used, and some cells on different rows are filled with a number different than 0, the rows which contain cells with 0, to hide automatically. And this should happen everytime that worksheet is used, with different values.

About the attached example:

- The value that changes is in column B
- D, E and F are merged cells on each row
- talking about the attached example: I need rows with Text2, Text 4 and Text 5 to be hidden automatically, because in B column the value is zero for these rows.
- IMPORTANT! - at each use of the worksheet, the rows that have 0 in column B are different. Not always the same. And also, this automatization must apply only to a certain selection in the document (let's say from rows 45 to 135).

Thank you very much in advance for your help!

Carla

Capture.JPG

The values in column B are entered manually. the range is between 1 and 100

Thank you!