Drill down pivot table data via VBA macro
 

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


--
jmon76
------------------------------------------------------------------------
jmon76's Profile: http://www.thecodecage.com/forumz/member.php?u=1909
View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=204538

http://www.thecodecage.com/forumz

Drill down pivot table data via VBA macro
 

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

Drill down pivot table data via VBA macro
 

Herbert Seidenberg;729985 Wrote:

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



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


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

--
jmon76
------------------------------------------------------------------------
jmon76's Profile: http://www.thecodecage.com/forumz/member.php?u=1909
View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=204538

http://www.thecodecage.com/forumz

Drill down pivot table data via VBA macro
 

In GetPivotData syntax,
you are missing Field1.
Added another tab to my example file,
simulating your multiple column layout.
Same link.
http://c0718892.cdn.cloudfiles.racks.../05_23_10.xlsm

Drill down pivot table data via VBA macro
 

Herbert Seidenberg;730004 Wrote:

In GetPivotData syntax,
you are missing Field1.
Added another tab to my example file,
simulating your multiple column layout.
Same link.
http://c0718892.cdn.cloudfiles.racks.../05_23_10.xlsm



I cant seem to access the file you loaded (and had the same issue last
time). Can you load a PDF like you did last time?

Thanks!


--
jmon76
------------------------------------------------------------------------
jmon76's Profile: http://www.thecodecage.com/forumz/member.php?u=1909
View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=204538

http://www.thecodecage.com/forumz

Drill down pivot table data via VBA macro
 

Pdf file, 3 pages:
http://www.mediafire.com/file/dzzttzmiq0m/05_23_10.pdf

Drill down pivot table data via VBA macro
 

Herbert Seidenberg;730018 Wrote:

Pdf file, 3 pages:
http://www.mediafire.com/file/dzzttzmiq0m/05_23_10.pdf



got it now. Thanks!!!


--
jmon76
------------------------------------------------------------------------
jmon76's Profile: http://www.thecodecage.com/forumz/member.php?u=1909
View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=204538

http://www.thecodecage.com/forumz