Sub Recap()
Sheets("resultat").Cells.Clear
Sh = "" & Range("D4")
Filt = Range("F4")
With Sheets(Sh).Range("A1:J" & Sheets(Sh).Range("A" & Rows.Count).End(xlUp).Row)
.AutoFilter Field:=1, Criteria1:=Filt
.Copy Sheets("resultat").Range("A1")
.AutoFilter Field:=1
End With
Sheets("resultat").Activate
End Sub