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:

Please Login or Register  to view this content.
I'm struggling to get the code to work and validate the other two boxes. Any help is appreciated.


Bippa**