Auto Filter - capture criteria used
 

I have a multi-column list that users can filter using the auto-filter
setting. How can I capture what filtering criteria they have used? I need
this to update report titles which include what filtering was used.

Auto Filter - capture criteria used
 

There's a sample file he

http://www.contextures.com/excelfiles.html

Under Filters, look for 'FL0007 - Highlight AutoFilter Headings'

In cells I1:O1 are formulas that return the filter criteria, based on a
user defined function that was posted by Tom Ogilvy.

Kolotti wrote:
I have a multi-column list that users can filter using the auto-filter
setting. How can I capture what filtering criteria they have used? I need
this to update report titles which include what filtering was used.


--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html

Auto Filter - capture criteria used
 

Thanks!! Exactly what I needed.

"Debra Dalgleish" wrote:

There's a sample file he

http://www.contextures.com/excelfiles.html

Under Filters, look for 'FL0007 - Highlight AutoFilter Headings'

In cells I1:O1 are formulas that return the filter criteria, based on a
user defined function that was posted by Tom Ogilvy.

Kolotti wrote:
I have a multi-column list that users can filter using the auto-filter
setting. How can I capture what filtering criteria they have used? I need
this to update report titles which include what filtering was used.


--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html