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

in help on auto filter the following is suggested
If .AutoFilterMode Then
With .AutoFilter.Filters(1)
If .On Then c1 = .Criteria1
End With
End If
Filters(1) would be the leftmost filter.
each one to the right will increment up by one.

"Evan" wrote:

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