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.
| Row Labels | Jan | Feb | Mar | Apr | May |
| 1 | 100.00 | 100.00 | 100.00 | 100.00 | 100.00 |
| 2 | 200.00 | 200.00 | 200.00 | 200.00 | 200.00 |
| 3 | 300.00 | 300.00 | 300.00 | 300.00 | 300.00 |
| 4 | 400.00 | 400.00 | 400.00 | 400.00 | 400.00 |
| 5 | 500.00 | 0 | 0 | 0 | 0 |
| | | | | | |
