Changing Pivot Table Value Field Labels with VBA
 

Hi All,

I have a data with three data columns

Month N
Month N+2
Month N+3

which store the the sales for each month.

At the present moment, I can label these as

Month N =Mar
Month N+2 =Apr
Month N+3 =May

Next month when the pivot will refresh I require the names to updated automatically using VBA macro.

Can anyone please help.

Thanks,
Nano