Create a button in excell to hide a row based on value in a cell in corresponding column.

Question

I want to create a button to "Hide" or "unhide" entire row based on values in corresponding cell D.

I have data in in column A to H & row 1 to 103. I want to hide all rows if value in cell D is "Not Applicable". i.e.

row 1 should hide if D1="Not Applicable"  

row 3 should hide if D3="Not Applicable"  etc.

And additional button to unhide all hidden row which are hidden by above button.

I have attached a screenshot to provide better understanding. 

Answer 1

Hi,

To hide rows then put a button on your worksheet and attach the code below. To unhide the rows attach another button and change the TRUE in bold to FALSE and attach that code.

Dim LastRow As Long, x As Long

LastRow = Cells(Cells.Rows.Count, "D").End(xlUp).Row

For x = 1 To LastRow

If UCase(Cells(x, "D")) = "NOT APPLICABLE" Then

    Rows(x).Hidden = True

End If

Next

Answer 2

Thank you very much Mike. It is working great.