Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Column = 5 And Target.Row > 8 Then
With Sheets("Feuille 1")
.Range("B7:G" & .[B65000].End(xlUp).Row).Name = "base"
End With
With Sheets("Feuille 2")
.Range("B8:F500").Clear
.[J2].FormulaR1C1 = _
"=AND('Feuille 1'!R[6]C[-5]="""",'Feuille 1'!R[6]C[-7]<>"""")"
Range("base").AdvancedFilter Action:=xlFilterCopy, CriteriaRange:=.Range( _
"J1:J2"), CopyToRange:=.Range("B7:F7")
.[J2].ClearContents
End With
End If
End Sub