| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Changing a field setting in a pivot table | Excel Discussion (Misc queries) | |||
| How do I repeat labels in Excel for a pivot table field? | Excel Discussion (Misc queries) | |||
| Changing Pivot Table Field Name | Excel Programming | |||
| Changing field in Pivot Table with macro | Excel Programming | |||
| Dynamically changing a calculated field in Pivot Table | Excel Programming | |||
Linear Mode
