Good morning/afternoon.
I seem to be having an issue in creating a macro to filter my pivot table depending on matching data within the hours columns.
The pivot table summarises the data from two time sheet entry systems to reconcile them - ensuring each employee's time sheets match.
The dates selected within one of the pivot tables filters has been pre selected prior to this point. What I am looking to get here is, if each of the hours match for the listed employee in both systems, It hides the hours entered for that employee (makes the pivot item not visible). That way, It will only show me the discrepancies to work through.
If anyone can shed some light and help out here I would be very grateful.
Thanks in advance.
Regards,
Jyae.
Bookmarks