I'm from the Dominican Republic and I work as a Media Analyst at an
Advertising Agencies. I need some help regarding the use of pivot tables.
The thing is I have a workbook with several worksheets and pivot tables
which I refresh at least monthly. There are some graphs that are linked
to the results of these pivot tables. As I told you, I update this
databases monthly, in order to elaborate monthly Competitive Advertising
Reports. Each time I do this i have to manually change the field month
for the current month. For instance it's January now and last month was
december, so I have to change the month in the drop-down menu for this
field for all pivot tables that apply. I was wondering if you could help
me out creating a macro to do this automatically.

One problem might be that not all pivot tables have the field month,
so
if I try to apply this setting for all pivot tables VBA will return me
an error, right?

Please help... It will be greatly appreciated,

Marcos RodrÃ*guez