| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Help with Pivot Table
Hi,
I need some help with pivot tables: Given a pivot table, and a selected cell within it, is there any way I can find out the Column Label and Row Label values that the cell is in? There's just so many functions in the PivotTable object model (get_HiddenFields, get_ColumnFields, get_DataFields, etc), and I've no idea where to start. | Column Labels | columnA | columnB | Item1 | 6 | 2 | + rowA | 2 | 2 | + rowB | 4 | | Item2 | 3 |12 | + rowB | | 4 (A) | + rowC | 3 | 8 | Total | 9 | 14 | Not sure if the diagram will load up correctly. If it does, assume that cell (A) is selected, and hence, I'm trying to get "Item2", "rowB" and "columnB". If the diagram is not formatted correctly, I've uploaded the image he http://img58.imageshack.us/img58/6053/pivottablesy5.png Please help. Thanks Josh |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how to create pivot table from existing pivot table in excel 2007 | Excel Discussion (Misc queries) | |||
| Copying values from pivot table to cells outside pivot table | Excel Discussion (Misc queries) | |||
| Filter lines containing pivot table and non pivot table data | Excel Worksheet Functions | |||
| How do I create a pivot table if the pivot table icon or menu ite. | Charts and Charting in Excel | |||
| Help required with setting up a pivot table with the source on sheet1 to have the pivot table created on sheet called "report" | Excel Programming | |||
Threaded Mode
