Guys,

is it possible to have something in vba that can select a field in a pivot table?

What i want to do is if a user has selected a specific field in a pivot table , is it possible that i can get a macro to select the field which is 1 before the selected field?


for example if the field the user is selecting in Periods 1-7. The user selects period 6, i want the macro to select period 5.

The fields in my pivot table are named as "2010-P02", these go from P01 to P13

Is this possible to do?

Regards,
Abz