Hello all,

I have a pivot table that is filtered based on the cell value of another cell, which contains a dropdown list. I also have the code to select multiple items from this data validation drop down list, and display them separated by commas. What I am looking to do is a multiple selection of the filter on the pivot table when i have multiple selections in the drop down. There is a disconnect between the cell value of the drop down with multiple selections and the pivot table filter itself when I do this.

Can anyone say if this is possible or not? Or offer a different way to go about this?

Thanks a bunch!