Sub Autre_2()
Dim D As Object, Rng As Range
Dim i&, j&, Rw&
Dim Treport As Variant
Set D = CreateObject("Scripting.dictionary")
With Sheets("UPTIME PAR TOOL SET")
Set Rng = .Range(.Cells(2, 1), .Cells(.Cells(Rows.Count, 1).End(3).Row, .Cells(1, Columns.Count).End(1).Column))
End With
Treport = Rng
With Sheets("Feuil1")
For i = 2 To .Cells(.Rows.Count, 1).End(3).Row
D(Trim(UCase(.Cells(i, 1)))) = ""
Next i
End With
For i = LBound(Treport, 1) To UBound(Treport, 1)
If D.exists(Trim(UCase(Treport(i, 1)))) Then
Rw = Rw + 1
For j = LBound(Treport, 2) To UBound(Treport, 2)
Treport(Rw, j) = Treport(i, j)
Next j
End If
Next i
Application.ScreenUpdating = False
Rng.Offset(Rw).Delete
If Rw Then Rng.Resize(Rw, UBound(Treport, 2)) = Treport
Application.ScreenUpdating = True
End Sub