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!
Bookmarks