can anyone help me?
Posted by Ben on May 11, 2000 2:03 AM
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" _
Set c = Selection.Find(What:=org_alias1)