hiding of unnecessary rows

[Rhon Alvarez]

Hi All,

Please help me come up with a formula that hides rows with zero (0) values.

Kindly see attached file and thank you in advance.

 

[Hui]

Rhon

Your table is currently 56 rows high with only 3 rows of data > 0

Do you want the table to be:

a) 3 rows high with the other rows hidden
b) 3 rows high with the other rows accessible using a +/- icon
c) 56 rows high with the 0 values not visible

I also assume you'll need some technique to unhide or make all rows visible

 

[Hui]

You can use some simple VBA code like

Sub HideRows()

Dim c As Range
For Each c In Range("B4:B59")
  If c.Value = 0 Then c.EntireRow.Hidden = True
Next


End Sub

Sub UnHideRows()
Range("B4:B59").EntireRow.Hidden = False

End Sub

Then link that to some buttons
see attached file:

 

[Rhon Alvarez]

Hi Hui,

Actually, I need all the product mode be included on the lists and hides only when we have no sales for the year. your VBA Code works great and this is just what I needed with your letter A parameter. unfortunately, I am not familiar yet and I don't know how VBA works so I think I have to study it.

thanks for the help!!