People

I have a large spreadsheet with Autofilters switched on.

Elsewhere I have some summary data of the filtered data e.g SUBTOTAL(9,)

But I need to know the value of the Autofilter they have selected from the
dropdown. The reason being I also want (in my summary data) to do some
DLOOKUP of other data stored elsewhere based on this autofilter for my
summary.

Can't seem to find a a way (or create a function) to get this value.

Any pointers?

TIA


Evan