Good morning
I have a drop down list containing a list of codes and their description.
On the same spreadsheet I have a pivot table where the user is invited to select a code to alter the view - the same code as listed in the list box I mention.
Is there a way to get the pivot table to look at the active selection in the list box and preselect that as the code to analyse ?!
Hope this makes sense !
Amy xxx
Bookmarks