| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Drill down pivot table data via VBA macro
|
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Pivot table drill down data | Excel Discussion (Misc queries) | |||
| Pivot Table Drill Down | Excel Discussion (Misc queries) | |||
| Pivot Table macro to set print area and print details of drill down data | Excel Discussion (Misc queries) | |||
| Macro to Format the Pivot Table drill down | Excel Programming | |||
| Top 10 within a drill-down in a pivot table? | Excel Discussion (Misc queries) | |||
Hybrid Mode
