VBA Code to control Slicers from different Raw Data Source

[Yadavgiri]

Hi All,

Request your help in getting VBA Code to control Slicers from different Data Source. I have attached the excel document.

There are 2 Data Source - (1) - Raw Data Source 1 & (2) - Raw Data Source 2.

There are 2 Sheets with Pivot and Slicers.

(1) Pivot - Raw Data Source 1 which is done with Raw Data Source 1.
(2) Pivot - Raw Data Source 2 which is done with Raw Data Source 2.

There are Slicers by name Weekday & Date in Sheet Pivot - Raw Data Source 1. Also there are slicers with the same name Weekday & Date in Sheet Pivot - Raw Data Source 2.

I understand that the slicers will control Pivot which you are being built with the same data source. However, would request your help in getting a VBA/Macro code where in when i select any data in Slicers which is given in Sheet Pivot - Raw Data Source 1 the changes has to be done in Pivots in Sheet Pivot - Raw Data Source 2 as well.

Your help is much appreciated. Kindly let me know for any clarifications.

Regards,
Yadavagiri