hindersaliva
asked on
Excel 2010 - Pivot Table from a Recordset
I can get my PivotTable data into a recordset from an external database. OK.
I'm looking for the minimal code required to create a PivotTable with this data.
Say, on "Sheet1", at "A1", with Page Fields "CustomerType" and "Country", Row Field "Customer", Values "Count of Shops".
Thanks.
(I tried recording a macro but translating it to datasource = recordset is where I'm stuck)
I'm looking for the minimal code required to create a PivotTable with this data.
Say, on "Sheet1", at "A1", with Page Fields "CustomerType" and "Country", Row Field "Customer", Values "Count of Shops".
Thanks.
(I tried recording a macro but translating it to datasource = recordset is where I'm stuck)
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
No comment has been added to this question in more than 14 days, so it is now classified as abandoned.
I have recommended this question be closed considering ID: 42068362 as best solution
If you feel this question should be closed differently, post an objection and a moderator will read all objections and then close it as they feel fit. If no one objects, this question will be closed automatically the way described above.
I have recommended this question be closed considering ID: 42068362 as best solution
If you feel this question should be closed differently, post an objection and a moderator will read all objections and then close it as they feel fit. If no one objects, this question will be closed automatically the way described above.
It would be helpful if you provide sample workbook.