Hide Rows Automatically

[jimboryan]

I am trying to find a way to hide individual rows of data when I am done with them. I start with a list of data, and as I finish with each I would like to hide it. I was thinking a helper row with a filter (hide rows with an 'x' in the helper row) but it doesn't seem to update automatically. Is there a simple way to do this?

[DBY]

Hello

One way if you're happy to use VBA, then the following code on a Button click would hide all rows in the specified range where column F as an 'x':

Sub Button1_Click()
Dim c As Range

For Each c In Range("F2:F20")
    If c.Value = "x" Then
        Rows(c.Row & ":" & c.Row).EntireRow.Hidden = True
    End If
Next c

End Sub