Sub Worksheet_Activate()
Dim L%, i%, T
Application.ScreenUpdating = False
With Sheets("mes_donnees")
T = .Range("I1:I" & .[I50000].End(xlUp).Row)
End With
[G3:H1000].ClearContents: L = 3
For i = 3 To UBound(T)
If Application.CountIf([Liste], T(i, 1)) = 0 And T(i, 1) <> "" Then
Cells(L, "G") = i
Cells(L, "H") = T(i, 1)
L = L + 1
End If
Next i
End Sub