stevembe
07-09-2013, 02:31 AM
Firstly thanks for reading my post and thanks for any help in advance.
Basically I have 2 pivot tables, each of which is linked to differing data on different sheets. The one common field is employee id which is a 4 figure number. I have placed slicers on a different sheet but what I want to be able to do is if an employee id is selected in pivots table 1 it automatically filters pivot table 2 with the same employee id. I was thinking perhaps VLOOKUP but I cannot seem to get it to work so perhaps VBA?
Basically I have 2 pivot tables, each of which is linked to differing data on different sheets. The one common field is employee id which is a 4 figure number. I have placed slicers on a different sheet but what I want to be able to do is if an employee id is selected in pivots table 1 it automatically filters pivot table 2 with the same employee id. I was thinking perhaps VLOOKUP but I cannot seem to get it to work so perhaps VBA?