Add/Remove Pivot Table Data Field VBA

biggsy3

New Member
Joined
Jan 27, 2014
Messages
40
Hi all,

Is there a macro i can use to add and remove pivot table data fields "values". When adding i would require it to be by average.

I'm a bit of a VBA noobie so would be grateful for any help on this.


Thank you in advance.
 

Some videos you may like

Excel Facts

How can you automate Excel?
Press Alt+F11 from Windows Excel to open the Visual Basic for Applications (VBA) editor.

Watch MrExcel Video

Forum statistics

Threads
1,108,970
Messages
5,525,961
Members
409,673
Latest member
Riseee

This Week's Hot Topics

Top