VBA code to handle variable Pivot Table items ???

[Guest]

I have a pivot table that works perfectly well. I'd like to create a macro
to automate my selection process but I have one big concern.
I pull data by ( lets say ) Regions on a daily basis....West, North, South,
East, Midwest, NorthEast, etc. How do I handle the fact that maybe on a
given day there may only be two regions available to choose from. Say, I
want to select the West region data...I have to uncheck all and then only
check West. Is there a trick workaround for this. In addition there may be
a day where a brand new region comes into the picture.......for example,
SouthEast. How do I incorporate this new Region
Any help or assitance would be greatly appreciated.
Joe

 

[Debra Dalgleish]

Is region a page field? A Row field?
What version of Excel are you using?
What kind of automation do you want to create?