I am currently sending out an exception report for multiple locations as an excel spreadsheet. The first sheet of the report is a list of all exceptions, and then the following sheets are by location. I would like the worksheets for each location to only generate if there are exceptions.
Example: There are three locations (A, B, and C) and here is a list of the exceptions:
| Location | Model | Days On Hand |
| A | Model1 | 30 |
| A | Model1 | 45 |
| C | Model1 | 30 |
| C | Model1 | 40 |
I would like an excel report that has a 'Master List' worksheet that includes all exceptions to be sent, a worksheet for just location A, and a worksheet for just location C.
Right now, I am using the 'Page' selection to list the different locations per worksheet, but all locations are included, even if that location does not have any exception (B would be included in the example above). Is there a way to only have locations that have data, or exceptions, to be included?
