Archive of Mr Excel Message Board


Back to Pivot Tables in Excel archive index
Back to archive home

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)

Ben


Re: can anyone help me?

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.

Ben


This archive is from the original message board at www.MrExcel.com.
All contents © 1998-2004 MrExcel.com.
Visit our online store to buy searchable CD's with thousands of VBA and Excel answers.
Microsoft Excel is a registered trademark of the Microsoft Corporation.
MrExcel is a registered trademark of Tickling Keys, Inc.