View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Pastal Pastal is offline
external usenet poster
 
Posts: 1
Default How can I auto refresh a column that has an auto filter in place

I am workin in Excel, and have an issue with filtering a column
automatically. The column is fed by formulas in the cells. I want to auto
filter the column (non-blanks) and this works fine. However, when the input
data is changed, and the column fills with new values, the filter is not
automatically re-applied, and I have to manually re-apply it. How can I
automize this process?