Results 1 to 2 of 2

Veryfying data on Pivot Table with another workbook

Threaded View

sonny.thind Veryfying data on Pivot Table... 04-16-2012, 11:19 AM
sonny.thind Re: Veryfying data on Pivot... 04-17-2012, 09:01 AM
  1. #1
    Forum Contributor
    Join Date
    07-04-2011
    Location
    London, Ontario
    MS-Off Ver
    Excel 365
    Posts
    119

    Veryfying data on Pivot Table with another workbook

    I am trying to find a way to highlight /compare the values on a pivot table ("PivotSheet.xlsm") for ZONE ID# by calling workbook and comparing date values from the ("pullsheet") workbook in column C for every subsequent day for the corresponding ZONE #ID.
    For e:g The zone ID# referenced in the PiVot Sheet attached is for a Saturday on the Pull sheet.
    quite simply the workbook ("pullsheets.xls") is just a reference sheet to verify if the zone capacity for that day are "null" or zero value on the ("PivotSheet").

    maybe I need to change the Title to Comparing Data rather than veryfying...
    Attached Files Attached Files
    Last edited by sonny.thind; 04-16-2012 at 12:54 PM. Reason: Change title to Comparing instead of Veryfying

Thread Information

Users Browsing this Thread

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

Tags for this Thread

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