Sub Bouton5_QuandClic()
Dim maintenant As Variant
Dim tablo As Variant
Dim tablo2()
Dim x As Integer, i, j, k
maintenant = Timer
tablo = Range('a1:d' & Range('a65536').End(xlUp).Row) '<=== à adapter
x = 1
For i = 1 To UBound(tablo)
For j = 1 To 4
If tablo(i, j) = 'x' Then
ReDim Preserve tablo2(1 To 4, 1 To x)
For k = 1 To 4
tablo2(k, x) = tablo(i, k)
Next k
x = x + 1
End If
Next j
Next i
Sheets('Feuil2').Range('a1').Resize(UBound(tablo2, 2), UBound(tablo2, 1)) = Application.Transpose(tablo2)
MsgBox Timer - maintenant
End Sub