How to update advanced filter automatically?

  • Thread starter Thread starter darius
  • Start date Start date
D

darius

Hi

I have an adv. filter with a criteria like this

date1 date1
=1/1/2 <1/1/3
Click to expand...

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
 
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
 
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
Click to expand...

Okay, thanks.
Given your criteria, couldn't you use the custom criteria from
autofilter, it will update whenever it is changed
Click to expand...

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