View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Simon Simon is offline
external usenet poster
 
Posts: 172
Default Flag 'Filter on' for the user

In Excel 2000, I want to create a 'flag' to alert the user whenever data is
filtered, and preferably tell the user what the filter is e.g. If a column
of dates is filtered on 'April', I would like the word 'April' to appear in
a separate cell in large letters and ideally on another worksheet, maybe
against a label that says 'currently filtered on:'