Afternoon,
What i'm trying to do is two fold. I have three pivot tables on one sheet that correspond to their own unique data set.
However, 50% of the data in each Table has the same Name i.e EmployeeName, Month, Date.
I have been able to write the code so that a data validation list will filter all three pivot tables with the same value, however the problem I have is when I want to duplicate that same code to validate against another two values, Month and Year, the code no longer works.
The code I have for the Name is:
I'm struggling to get the code to work and validate the other two boxes. Any help is appreciated.
Bippa**
Bookmarks