Private Sub Worksheet_Activate()
With Feuil1 'CodeName de la feuille source
With Intersect(.Rows("3:" & .Rows.Count), .UsedRange)
.AutoFilter
.AutoFilter 5, "Oui"
If Me.FilterMode Then Me.ShowAllData 'si la feuille est filtrée
.Copy [A3]
.AutoFilter
End With
Rows(Application.CountIf(.[E:E], "Oui") + 4 & ":" & Rows.Count).Delete
End With
End Sub