MrExcel Publishing
Your One Stop for Excel Tips & Solutions

can anyone help me?

Posted by Ben on May 11, 2000 2:03 AM

Hi everyone,
hopefully someone has done this before
What I'm trying to do is find a particular item in a Row Field.

The Pivot table I am looking at has 2 Row Fields:
Cluster is first, org_alias is second, then a "sum of cost" Data Field feeds off these two. My search is firstly for "Cluster", then once that is found, I want to search "org_alias" for a particular item. Problem so far is that I can't seem to select the "org_alias" field to search it.

I can do it manually, but this doesn't seem to translate to procedure in VBA code. This isn't too clear I guess, but if anyone is an expert in Pivot Tables, I would love to hear from them!!

Here's a sample of the "macro recorder":

ActiveSheet.PivotTables(1).PivotSelect "Cluster" _
org_alias[All]", xlDataAndLabel

Set c = Selection.Find(What:=org_alias1)


Posted by Ben on May 11, 2000 7:18 AM

Just in case anyone was interested, I worked it out! Yay

It's a bit too idiomatic for this page though.