I am a volunteer committee member for a local football league and one of my tasks is to collate a list of teams who have not submitted reports for some/all of their matches and e-mail this list to the team manager and their club secretary.

I am using the code below:

Private Sub Worksheet_Change(ByVal Target As Range)
If Target = Range("g2") Then
Range("A6:a1182").CurrentRegion.AdvancedFilter _
Action:=xlFilterInPlace, _
CriteriaRange:=Range("g1:g2")
End If
End Sub
This appears to bring up all records containing the data in cell G2 but I need only those records that are an exact match with cell G2.

Please could someone tell me where I am going wrong.

Thanks in advance.