Filtering multiple pivot tables using a common Slicer/Filter dropdown

[floragray]

Hi All,

Need your help with something -

I have a Excel workbook with multiple report tabs.
All these reprots are pulling data from different source tables in a database.
The data has then been summarized into Pivot tables.
The only common element between all the reports is a field called Serial Number.(but even this serial number is coming from a different source in each table.

On a separate page, I need to create a like a Filtering Bar which is linked to all the reports on the different tabs.

So if i have a selection of just serial number 3, for example, all reports only display data for 3.

Also i need to be able to filter ranges, so for example, if i choose Sr. no 5-17, all reports have data for the 15 records selected.

Can this be done with Slicer, that is connecting a Slicer to multiple pivot tables. Or will some VBA code have to be written for this??

If so, could someone please help me with this??

Thank you,,

 

[RoryA]

You will need code because you will have to attach the slicer to a dummy pivot table and then use that table's update event to synchronise the filters of the other tables - see for example Debra's page here: Change All Pivot Tables With One Selection | Contextures Blog