Link to home
Create AccountLog in
Avatar of hindersaliva
hindersalivaFlag for United Kingdom of Great Britain and Northern Ireland

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)
Avatar of Shums Faruk
Shums Faruk
Flag of India image

Hi,

It would be helpful if you provide sample workbook.
ASKER CERTIFIED SOLUTION
Avatar of Shums Faruk
Shums Faruk
Flag of India image

Link to home
membership
Create an account to see this answer
Signing up is free. No credit card required.
Create Account
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.