display which AutoFilter was selected in a different cell
display which AutoFilter was selected in a different cell
(OP)
Say I have a column of cells, some saying "open", some saying "closed" that are AutoFiltered. I want to know if it is possible to have a cell that displays which filter was selected with the pull down. So I can say "displying: XXXXX jobs" in a cell near the top so people know the sheet is displaying only XXXXX types of jobs.
possible? thanks in advance.
possible? thanks in advance.





RE: display which AutoFilter was selected in a different cell
TTFN
FAQ731-376: Eng-Tips.com Forum Policies