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