Private Sub Worksheet_PivotTableUpdate(ByVal Target As PivotTable)
If Target = "Tableau croisé dynamique2" Then
Dim filtre As String
With ActiveSheet
filtre = .Range("B1")
.PivotTables("Tableau croisé dynamique3").PivotFields("Mat"). _
CurrentPage = filtre
End With
End If
End Sub