One filter for multiple Pivots

Hi,

I have 2 separate pivots running off 2 separate data sources. The filters used for each or fairly similar (bar one entry).

Is there a way to have one filter that filters the information in both pivots even though they are not based on the same data source?

Also, with the filter that is slightly different; in one table, I have an option that shows (this is just an example) 'retail and end user' yet, in the other table these are two separate options.

Any suggestions or solutions would be greatly appreciated.

Thanks.

Hi Stephen,

Thanks for the link. Unfortunately, I haven't been able to find anything in these posts that might help. Anything that looks remotely similar I can't use as I am a newbie when it comes to VBA so wouldn't know where to start modifying them.

I've thought about using cell references as the trigger but I need to use multiple selections which wouldn't work.

If there are any other solutions out there to my problem, I would be grateful to here them.

Thanks.

How about utilising a slicer and connecting both pivots.

Hi AJE,

I'm using multiple data sources hence slicers won't work. I've been told and seen elsewhere that VBA might be the solution but I have no idea about how this might work.