Hello,
I am working with School data and each school can have a range of year levels (e.g primary = 3, 4, 5, secondary = 7, 8,9 or combined (3-9).
I'm using VBA to generate multiple reports for these schools but was hoping I could add some additional code to be applied to some of my pivot table filter/slicers.
Is there a way I can code the macro to always select the first Pivot Table item of a set Pivot Table field?
I've only been able to solve this in a very clunky way and it doesn't cover all the combinations of schools I have neatly.
An example of what I have now
HTML Code:
Bookmarks