Prev: can i create a reminder to pop up in excel?
Next: Date programing in a cell
From: jmon76 on 22 May 2010 22:12

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/showthread.php?t=204538

http://www.thecodecage.com/forumz

From: Herbert Seidenberg on 23 May 2010 13:15
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

From: jmon76 on 23 May 2010 14:31

Herbert Seidenberg;729985 Wrote:
>
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



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/showthread.php?t=204538

http://www.thecodecage.com/forumz

From: Herbert Seidenberg on 23 May 2010 16:02
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.rackspacecloud.com/05_23_10.xlsm

From: jmon76 on 23 May 2010 16:08

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.rackspacecloud.com/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/showthread.php?t=204538

http://www.thecodecage.com/forumz

 |  Next  |  Last
Pages: 1 2
Prev: can i create a reminder to pop up in excel?
Next: Date programing in a cell