View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Looping through Looping through is offline
external usenet poster
 
Posts: 69
Default Pivot filter Help

Is there a way to filter a pivot table field based on a cell range within the
sheet?

I want to filter out all results except whatever is listed in cell a2. this
can be a number or text. the pivot table field list can have as many as 300
options.

Any help is greatly apprechiated.
Peter