View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
tag tag is offline
external usenet poster
 
Posts: 2
Default pivot table drop list

I have 2 pivot tables each with a page drop down list. My
goal is to have the 2nd pivot table update when the user
makes a selection from the first table's drop down.

Example: User selects "apples" from table 1 drop down.
Table 1 and table 2 displays data for "apples" as opposed
to user having to make 2 selection.

Make sense?