There is a "Status" field in my workbook that captures 20 different statuses based on phase in project. (Not all 20 items are actively used.)
In my pivots I only need to capture 15 of the 20 statuses.
Problem: I can't pre-select or auto-select the items I want because not all of them are active at all time and thus they don't show up in the pivot table field list items.
Ex. Phase 4 and Phase 5 statuses are used rarely,that is why every single time I have to manually update items under Status in the pivot field list to make sure it captures all the statuses i want.
I can't record macros for this, because if one status is not active, the macro will run into a bug trying to find that status.
Solution: I believe I need a VBA code to autoselect the pre-designated items under status if they are visible/active.
In my pivots I only need to capture 15 of the 20 statuses.
Problem: I can't pre-select or auto-select the items I want because not all of them are active at all time and thus they don't show up in the pivot table field list items.
Ex. Phase 4 and Phase 5 statuses are used rarely,that is why every single time I have to manually update items under Status in the pivot field list to make sure it captures all the statuses i want.
I can't record macros for this, because if one status is not active, the macro will run into a bug trying to find that status.
Solution: I believe I need a VBA code to autoselect the pre-designated items under status if they are visible/active.
