Need to filter pivot on multiple items defined in range on separate worksheet

[Nmarkit]

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 vba code or point me in the right direction? I attach a sample file

Thanks!

[romperstomper]

A simple way would be to add a formula column to the source data:
=ISNUMBER(MATCH(F2,product,0))

and then add that field to the pivot filtering for True. Then all you need to do is refresh the pivot when the criteria change.

[Nmarkit]

Thanks for your quick response Rory.

however what i'm looking for is to have the pivot update dynamically. so when the user selects certain products from the filter (listbox) the pivot gets updated to those products. i don;t want to manually refresh the pivot each time. i'm using vba for my report and so far have been able to pull through the selected products from the filter and dump it in the product range. now am stuck on how to update the pivot on this range....

[romperstomper]

If you use the formula, then your code simply needs one more line to refresh the pivot table after updating the product list.