How can an Array of data be written into a Pivot Tables PivotCache?
The worksheet: "Actuals" has a pivot table called: "PvtTransByMonth"
The current PivotTable's PivotCache / Source has the fields:
- Source -> xlPageField,
- Category -> xlRowField,
- Year -> xlColumnField,
- Month -> xlColumnField,
- Description (not used in this pivot), and
- Amount ->xlDataField
The array named: "arrTransacts" has 6 elements:
arrTransacts(0) = Source
arrTransacts(1) = Category
arrTransacts(2) = Year
arrTransacts(3) = Month
arrTransacts(4) = Description
arrTransacts(5) = Amount
In VBA, How do I set up and write the array into the PivotTable's PivotCache?
Any Help appreciated.
Respectfully,
John
The worksheet: "Actuals" has a pivot table called: "PvtTransByMonth"
The current PivotTable's PivotCache / Source has the fields:
- Source -> xlPageField,
- Category -> xlRowField,
- Year -> xlColumnField,
- Month -> xlColumnField,
- Description (not used in this pivot), and
- Amount ->xlDataField
The array named: "arrTransacts" has 6 elements:
arrTransacts(0) = Source
arrTransacts(1) = Category
arrTransacts(2) = Year
arrTransacts(3) = Month
arrTransacts(4) = Description
arrTransacts(5) = Amount
In VBA, How do I set up and write the array into the PivotTable's PivotCache?
Any Help appreciated.
Respectfully,
John