Private Sub Worksheet_activate()
Worksheet_Change [B2] 'lance la macro
End Sub
Private Sub Worksheet_Change(ByVal Target As Range)
Application.ScreenUpdating = False
Application.EnableEvents = False 'désactive les évènements
Range("C2:O" & Rows.Count).Delete xlUp 'RAZ
With Sheets("Parties")
If .FilterMode Then .ShowAllData 'si la feuille est filtrée
With .Range("B3:N" & .Range("B" & .Rows.Count).End(xlUp).Row)
.AutoFilter 3, [B2].Value 'filtre automatique
.Copy [C2] 'copier-coller
.AutoFilter
End With
End With
Application.EnableEvents = True 'réactive les évènements
End Sub