Sub RecopieSansCopie()
Dim f As Worksheet, DerCol&, lig&, t
Set f = ActiveSheet
DerCol = f.Cells(19, f.Columns.Count).End(xlToLeft).Column ' à adapter selon besoin
With f.AutoFilter.Range
lig = .Offset(1, 0).SpecialCells(12).Row
t = Range(f.Cells(lig, 2), f.Cells(lig, DerCol)).Value
End With
Feuil2.Range("B12").Resize(UBound(t, 1), UBound(t, 2)).Value = t
End Sub