Drill down pivot table data via VBA macro

J

jmon76

I am trying to create a macro that will drill down subtotals from
pivot table. Since the number of rows, and colums, changes frequently
need to reference the total for the row or column. Can this be done vi
VBA macro?
 
J

jmon76

Herbert said:
Excel 2007 PivotTable
Show subtotal details via macro.
Define subtotal with PivotFields.
http://c0718892.cdn.cloudfiles.rackspacecloud.com/05_23_10.xlsm
Pdf preview:
http://www.mediafire.com/file/0ynnccqzeml/05_23_10.pdf
Click to expand...



hrm, that doesnt seem to work for me. I am posting a snip of my tabl
and code hoping you might see the issue.


+-------------------------------------------------------------------+
|Filename: MacroIssue.docx |
|Download: http://www.thecodecage.com/forumz/attachment.php?attachmentid=596|
+-------------------------------------------------------------------+
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Pivot table drill down sort 0
VBA Dynamic range in Pivot table 0
How I can set dynamic pivot table ONLY when I have enough data point 1
Excel 2007 - Drill-through action called via VBA locks the workshe 0
Using VBA to create charts 1
Get Pivot data not reading some cells 0
How do I set a default format of the drill down table? 0
VBA Pivot Table Error 1

Top