Sub ChercheData()
Dim DL, c, i, j
Application.ScreenUpdating = False
Range("B2:B" & (1+Range("B65500").End(xlUp).Row)).ClearContents
DL = Range("H65500").End(xlUp).Row
tablo = Sheets("Feuil2").[A1].CurrentRegion
IndW = 2
For c = 2 To DL
Critere = Cells(c, "H")
For i = 2 To UBound(tablo)
If tablo(i, 1) = Critere Then
For j = 1 To 4
Cells(IndW, j + 1) = tablo(i, j)
Next j
IndW = IndW + 1
End If
Next i
Next c
End Sub