Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Address = "$B$8" Or Target.Address = "$C$8" Or Target.Address = "$D$8" Then 'critère
Range([B10], Range("U" & [B10].End(xlDown).Row)).Clear
Sheets("DATA").Range("A1:T4000").AdvancedFilter Action:=xlFilterCopy, _ 'feuille source
criteriaRange:=ActiveSheet.Range("B7:D8"), CopyToRange:=ActiveSheet.Range("B10"), Unique:=False
End If
End Sub