Changing Pivot Table Value Field Labels with VBA

N

Nano

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

adding more data to pivot table. 3
Pivot from multiple sheets 1
sum working hours each month (sum hours in the last row for a monthin a table with dates) 3
Selecting Date Range in a Pivot using VBA 0
Use Sum() with variable range 4
In Pivot table sort 1
find a value in a table based on 2 different criteria 17
Retrieve Numeric Label for Max Value by Specific Month 8

Top