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?

pivot table drop list
 

See my answer :-

http://www.excelforum.com/showthread...threadid=20988

--
Message posted from http://www.ExcelForum.com