display filter selection from menu

[labgeek]

I'm working with a pivot table in which I have a "report filter" for
"county". I choose some counties from the pull down menu to run my
calculation. I would like to be able to display, in a different part of the
spreadsheet, the counties that I chose. In order for my calculations to be
correct, the county field must be in the "report filter" portion of the pivot
table.

 

[Sean Timmons]

Are you only wanting to show the current county selection, or do you want to
show the list of most recent selected? For current, just do a simple =B1 to
show county name. Otherwise, you'd be looking at programming...

 

[labgeek]

I only need to display the current choices from the dropdown menu, but I am
selecting multiple counties for a given scenario. I need to be able to list
the selected counties so I can confirm that I chose the correct counties for
each grouping.