VBA to connect two slicers from two different data/cache.

If I understand what your asking, then thats not the way it is meant to work.

As I understand it you have:

• 2x data sets
• 2x Pivots (1 per data set)
• Want to use a slicer that can control both?

If the above is correct this doesnt work as Excel has no way of ensuring that the field is in both data sets as they are unrelated/independent. Regardless of if you and I as human beings are smart enough to look at both and realize the 2 data sets share a relationship between fields...Excel is dumb and sees no such connection, it views them as 2 separate batches of data unrelated to each other.

This leads to the concept of relational databases and relationships between tables/data sets. You could potentially use PowerPivot and data models to relate the data to each other and then work with it, however that could be like killing an ant with a machine gun.

You could alternatively merge your data if both sets share the same fields onto another sheet and then base everything off of the consolidated data table.

VBA or not, this is just how data works in Excel. You may be able to use VBA to consolidate the data or manipulate the data model but honestly, its just another layer of complexity that you are best off manually putting to the test before attempting to code it.