VBA to through a Pivot Table column and apply each value to a slicer

[David Evans]

Hello folks -

I have two pivot tables - one lists a bunch of account relationships and their total value. The other has the individual accounts that make up the overall relationship.

I want to go into table 1, select the first value in field "Family" - take that value and apply it to table 2 to produce a more detailed relationship report that I use to feed a calculation.

Anyone got any ideas - manually I do it using a slicer, but programmatically, I don't think I'll need that, will I?

All thought gratefully accepted - brilliant ideas rewarded ...

 

[jeffreyweir]

Hi David. Slicers can act on more than one PivotTable if they are based on the same data source. See my article at http://dailydoseofexcel.com/archives/2014/08/16/sync-pivots-from-dropdown/