Hi,
Is there a trick to link the search field in the Pivot to a listing outside of the pivot?
I would like to filter all the items in the pivot by just 9 products.
Currently, i m doing one by one and selecting 'add current selection to filter'. Sometimes i might miss the click and I need to start again Doh!
Is there a way to get this done with VBA but that it can be used all the time, just thinking aloud.
Thanks,
josvilll2010
Bookmarks