Autofilter updating automatically

  • Thread starter Thread starter brian.baker13
  • Start date Start date
B

brian.baker13

Hi

I have an autofilter that checks on a Planning Board and is set to
filter out non-blanks. When the Planning Board Updates the autofilter
is not updating automatically to show that a new entry has been made
on the Planning Board.


All the updates that occur occur within the range of the autofilter

Is there anyway of doing this?


Thanks


Brian
 
You didn't like the reply at your other post?

[email protected] said:
Hi

I have an autofilter that checks on a Planning Board and is set to
filter out non-blanks. When the Planning Board Updates the autofilter
is not updating automatically to show that a new entry has been made
on the Planning Board.

All the updates that occur occur within the range of the autofilter

Is there anyway of doing this?

Thanks

Brian
Click to expand...
 
Brian,

in another post you have asked about macros, so if you are thinking of
including some you could also think about applying your filter
programatically - Debra Dalgleish has some notes here:

http://www.contextures.com/xlautofilter03.html

You could record a simple macro while you apply the filter for non-
blanks, and use Debra's examples to tidy the recorded macro up.

Hope this helps.

Pete
 
Back
Top