Autofilter updating automatically

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

brian.baker13@googlemail.com - 20 Nov 2007 20:47 GMT

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

Reply to this Message

Dave Peterson - 20 Nov 2007 20:53 GMT

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

> Hi
>
[quoted text clipped - 10 lines]
>
> Brian

Signature

Dave Peterson

Reply to this Message

Pete_UK - 21 Nov 2007 00:36 GMT

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

On Nov 20, 8:47 pm, "brian.bake...@googlemail.com"
<brian.bake...@googlemail.com> wrote:

> Hi
>
[quoted text clipped - 10 lines]
>
> Brian

Reply to this Message

Rate this thread: