Sub filtre()
With Range("A1")
.AutoFilter Field:=1, Criteria1:="<>A", Operator:=xlAnd, Criteria2:="<>B"
.AutoFilter Field:=2, Criteria1:="<>E", Operator:=xlAnd, Criteria2:="<>F"
End With
With ActiveSheet.AutoFilter.Range
Set rngfilter = .Offset(1, 1).Resize(.Rows.Count - 1, 1).SpecialCells(xlCellTypeVisible)
End With
rngfilter.Copy Sheets("Resultat").Range("A1")
ActiveSheet.AutoFilterMode = False
End Sub