Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Pivot Table Grouping
Hi All -
Hope someone can help with my question. I am trying to build a pivot table using vba. My problem comes when trying to manually group fields with text labels. I have two fields named "Adjustments" and "Charges" which need to be grouped so I can get a total. My question: Does anyone know how to refer to these Labels in code other than just using the cell reference? I have tried the PivotSelect statement but that will not work when trying to select two fields. Maybe if I can get the address returned and then use that as input for the range.select? Any insight would be appreciated. Thanks. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Grouping in pivot table | Excel Worksheet Functions | |||
Pivot Table Grouping | Excel Discussion (Misc queries) | |||
Grouping with a pivot table | Excel Worksheet Functions | |||
Pivot Table or Grouping Help | Excel Discussion (Misc queries) | |||
Pivot Table Grouping | Excel Worksheet Functions |