display which AutoFilter was selected in a different cell

[shawnpeter]

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.

 

[IRstuff]

That'll depend on how many filters you have on, but you'll need to write some VBA code for that. Look in the VBA help for AutoFilter Object.

TTFN

FAQ731-376