+ Reply to Thread
Results 1 to 1 of 1

Issue with filtering pivot table items depending on matching data.

  1. #1
    Registered User
    Join Date
    05-24-2013
    Location
    England
    MS-Off Ver
    Excel 2010
    Posts
    8

    Exclamation Issue with filtering pivot table items depending on matching data.

    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.
    Attached Files Attached Files

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1