Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Retrieve Data from a pivot table
I'd like to retrieve data from a pivot table using the pivotitems
object, NOT using pivotselect (I'd rather not select away from my active cell. I just need to look up values in the table) If I have a table with Rows A, B, C etc. and Columns Max and Min, max min A 14 2 B 16 1 C 25 3 I can use PivotFields & PivotItems to tell me the names of A, B, C and the names of the columns, but what do I use to reference the actual values? They must be objects also, right? Thanks so much, I always learn so much from you guys. -Lisa |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Retrieve Data from a pivot table
I found it! It's the GetData method. Sometimes you just have to take
a break and come back to the screen with fresh eyes. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Retrieve Data to Pivot Table "On Demand" | Excel Worksheet Functions | |||
Lookup data in a variable table & retrieve data from a pivot table | Excel Worksheet Functions | |||
Using 2 cells in a table to retrieve data from another table | Excel Worksheet Functions | |||
VBA Code - Retrieve SQL 2000 data -Pivot Table | Excel Programming | |||
[Pivot] Retrieve Data | Excel Programming |