Private Sub Worksheet_SelectionChange(ByVal Target As Range) If Intersect(Target(1), Range("D7:H10")) Is Nothing Then Exit Sub Worksheets("sheet2").Activate With ActiveSheet.Range("D6").CurrentRegion .AutoFilter .AutoFilter Field:=1, Criteria1:=Cells(Target(1).Row, "D").Value .AutoFilter Field:=2, Criteria1:=Cells(6, Target(1).Column).Value End With End Sub