Private Sub Worksheet_Activate()
Feuil3.[B4
48].ClearContents
With Feuil2
i = 4
For lig = 4
To .[D65000].
End(3).Row
If .Cells(lig, 8) =
"OUI" Then
Feuil3.Cells(i, 2) = .Cells(lig, 2)
Feuil3.Cells(i, 3) = .Cells(lig, 3)
Feuil3.Cells(i, 4) = .Cells(lig, 4): i = i + 1
End If
Next
End With
End Sub