|Hi, I have a workbook with one main tab and 16 other tabs (mainly charts that are derived from pivots). The source of all pivots is the main tab.|
In the main tab, one of the fields is a “Status” field that changes almost daily. This field is one of the main filters in my pivots for the charts.
I want to create a macro that would look at the filters in the pivots and mark all the statuses that are there. I have the following macro so far, but the problem is if one of these statuses is not active and thus is not in the main tab the macro runs into a bug because it can’t find that particular field.
I need something like an “if command” that says if this status exists then mark the existing filter in pivot field.
I would appreciate the help.