Thu 17 Jul 2008, 16:35Delegate Allister said...
Allister has attended:
Excel VBA Intro Intermediate course
Pivot Tables
How do select an extra columns for your pivot table within your VBA code?
Thu 24 Jul 2008, 11:05Trainer Carlos said...
RE: Pivot Tables
Hi Allister
To display extra data on a pivot tables column area you just add an extra field and the the fields positions. For Example:
.PivotFields("Salesperson").Orientation = xlColumnField
.PivotFields("Salesperson").Position = 1
.PivotFields("Make").Orientation = xlColumnField
.PivotFields("Make").Position = 2
Hope this helps
Carlos
