Hello

I have a pivot table with client name, volume, product and dates. Something like the below

Client Name: ABC capital

Sum of TRADES Column Labels
Row Labels Bond CDS Indices IRS

2012
Aug 3 1 29
Sep 9 1 27
Oct 53 3 7
Nov 56 3 78
Dec 59 3 21

on a separate worksheet i have a list of products defined in a range - "product". this list changes depending on the selection made by the user from a drop down list. what i need is that depending on the values within this range the pivot table filters the products. Can someone please provide the code or point me in the right direction?

Thanks!