Auto Filter - capture criteria used

[Kolotti]

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]

There's a sample file here:

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]

Thanks!! Exactly what I needed.

There's a sample file here:

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.