I have a PivotTable of stores of rent payments by month conditionally formatted to highlight a month where the rent was 0. I want to pull all the stores where rent was missed in the batch payment for that month to a new sheet. For example, my PivotTable looks like the below. How do I pull store #5 with the store # and months, whenever that month, 0 was processed? The goal is to do that for all 1500 stores so I can see more quickly when a month was missed.