Dear all,

I'm working on a graphical dashboard where I see different KPI's graphical represented. Different pivots are behind this. I already made three macro's to filter on a specific group. With three options, this was doable, but now I want to filter on each of our suppliers and I want to use a drop-down list for that.

The macro for the three options, looked like below.

Sub PaCo()
'
' PaCo Macro
'

'
Sheets("Pivot MCR").Select
ActiveSheet.PivotTables("PivotTable5").PivotFields("Location").CurrentPage = _
"(All)"
Sheets("Pivot SRLIP-CLIP").Select
ActiveSheet.PivotTables("PivotTable2").PivotFields("Location").CurrentPage = _
"(All)"
Sheets("Pivot SRLIP-CLIP").Select
ActiveSheet.PivotTables("PivotTable3").PivotFields("Location").CurrentPage = _
"(All)"
Sheets("Pivot SL2").Select
ActiveSheet.PivotTables("PivotTable4").PivotFields("Location").CurrentPage = _
"TG PaCo performance"
Sheets("Pivot complaints").Select
ActiveSheet.PivotTables("PivotTable1").PivotFields("Location").CurrentPage = _
"(All)"
Sheets("pivot leadtime").Select
ActiveSheet.PivotTables("PivotTable1").PivotFields("Location").CurrentPage = _
"(All)"
Sheets("Supplier Dashboard").Select
End Sub

The drop-down list I created with a form control 'Combo box', but now I need to add the correct macro, which I don't know how to write. If I select a certain supplier from the drop-down list, I want that all the pivots behind are filtered on that supplier automatically, so that my graphs are updated.

Thanks already for your feedback.