• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User


  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

How do i filter a pivot based on my Dropdown selection.

GraH - Guido

Well-Known Member
Why not simply use a slicer?
If you are after a VBA solution, then this thread should move to the VBA section.

GraH - Guido

Well-Known Member
Your code works with this small tweak
With ThisWorkbook.Worksheets("PT1").PivotTables("PivotTable1").PivotFields("Customer")
        .CurrentPage = Target.Value2
 End With


New Member
Yes #5 has a dropdown that I am using which is a form control. I need to filter my pivot based on that. Previously I had share a list box created in data validation.


Excel Ninja
Do You need both?
As You wrote #6 Reply Actually I was looking to edit using the combo box.

Now You have two 'same thread' open ... hmm?

Other thread closed now - no duplicates.
No need to send same file many times.
Last edited: