Auto Hide Row when cell contains specific text

[MarkRussell]

Good evening all.

I have a tasking database in Excel that gathers data from participants via forms. Once this info is assessed, a decision is made whether to take on the work or reject it. Once decided and the task is complete, the employee is required to select "Completed" in the cell.

Once the Cell has "Completed" selected from the drop down in column AA, I would like Excel to automatically hide the completed task from view.

I have tried a number of bits of code from different forums, but I just cannot make it work for my database. Is anyone able to help at all?

I hope this makes sense.

Thanks.

 

[John_w]

In the sheet module of the sheet in question:

Private Sub Worksheet_Change(ByVal Target As Range)

    If Not Intersect(Target, Columns("AA")) Is Nothing And Target.CountLarge = 1 Then
        Application.ScreenUpdating = False
        Target.Rows.Hidden = Target.Value = "Completed"
        Application.ScreenUpdating = True
    End If
    
End Sub

 

[MarkRussell]

In the sheet module of the sheet in question:

Private Sub Worksheet_Change(ByVal Target As Range)

    If Not Intersect(Target, Columns("AA")) Is Nothing And Target.CountLarge = 1 Then
        Application.ScreenUpdating = False
        Target.Rows.Hidden = Target.Value = "Completed"
        Application.ScreenUpdating = True
    End If
   
End Sub

It doesn't seem to be working. But this could be entirely down to my novice skills. I'll keep trying with it. Thanks for the help.