I just recorded a macro - but don’t find it dynamic.
There is a pivot table that has a pivot filter. Now if you press the button, it reset to certain pivot filter values. If you see the macro-
it basically turns on all the field values >>
ntPage = _
and then switches off all the remaining values. >>
e = False
ible = False
This code is not at all dynamic and everytime the data changes, I have to adjust it? This is not dynamic. How do I accomplish the same goal by just telling the vba code to selectively filter for a set of values (Central and East) - ?