Identifying Filtered Data

[Fujirich]

I have a simple worksheet I'm developing for some of my sales personnel that they can use to keep record of accounts being pursued. I'm using autofilter to enable easy searching of the data.

What I'd like to do is identify (as text) when the list is filter, and by what criteria. Here's what I envision as ideal:

1) User enables autofilter and selects a filter criteria from one of the headings

2) In a text line, I'd like to display something like "List is being filtered by (column heading) and (item selected)"

That's it - any ideas about how to do this?

Thanks in advance for any help!

Rich

 

[Greg Truby]

Rich - through an intersection of threads with Tom, I linked into this. Looks like Tom took good care of you here. But should you ever need to re-visit the subject, you might also take a look at this thread.