Retrieve Data from a pivot table

  • Thread starter Thread starter lisamariechemistry
  • Start date Start date
L

lisamariechemistry

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
 
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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Pivot table - unwanted lines 2
Pivot Table Filtering - Macro 3
Excel Pivot Items Using C# - Unable to Access 1
Automatically Update a Pivot Table Field Used as Column / Row 1
remove/delete/hide/exclude all (Blanks) in a pivot table macro 3
Pivot Table - How do I "Show All Data" of a particular field? 6
relation between fields in PivotTable 4
delete selection in pivotcolumn 3

Back
Top