Dashboards: Using slicers for different sets of data

[loggiaaj]

I love the Slicer, but how do I link a slicer for different data sheets e.g.: Expense Report on one tab and Labor report on another tab, as I find that as long as you use pivot tables off the same data you can link the Pivot tables using Slicer connections; but can you link Pivot tables between 2 different sets of data???

 

[Jerry Sullivan]

A slicer can only be used for PivotTables that share the same PivotCache- which also means they need to share the same source data.

VBA can be used to filter PivotTables to match the filtering on a PivotTable that is treated as the master.

 

[loggiaaj]

Thank you, how difficult is it to learn VBA, for this purpose???

 

[Jerry Sullivan]

Thank you, how difficult is it to learn VBA, for this purpose???

That's pretty hard to quantify. I'd suggest you try adapting the code in this thread as a way to get started....

http://www.mrexcel.com/forum/excel-questions/595213-pivot-table-master-report-filter.html

Just ask if you need some help.