How to update advanced filter automatically?

[darius]

Hi

I have an adv. filter with a criteria like this

date1 date1

=1/1/2 <1/1/3

how can I make the filter update automatically when I change the date in
the criteria. Only way I can do it now is to select Data -> Filter ->
Adv. Filter, and click Okay.

thanks

 

[Peo Sjoblom]

There is no way to do it automatically, you would need an event macro to do
it.
Or you can record a macro and attach a short cut key combination, then
manually
do what you are doing now. Then you could run the macro with a shortcut
whenever you alter the dates
Given your criteria, couldn't you use the custom criteria from autofilter,
it will update whenever it is changed

 

[darius]

There is no way to do it automatically, you would need an event
macro to do it.
Or you can record a macro and attach a short cut key combination,
then manually
do what you are doing now. Then you could run the macro with a
shortcut whenever you alter the dates

Okay, thanks.

Given your criteria, couldn't you use the custom criteria from
autofilter, it will update whenever it is changed

I will still need some kind of macro otherwise it's a pain to do manually
each time.