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...
Bookmarks