Autofilter updating automatically

[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

 

[Dave Peterson]

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

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

 

[Pete_UK]

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