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,
-...