Advance filtering Update

A

Alberto Ast

I have just learn to use advance filter but not succedd to update table when
I change the filter field...

Is there a way to do it automaticaly instead of going into the
data-filter-advance filter menu again?

I appreciate any help I can get to make this happen.
Thanks.
 
P

Patrick Molloy

advance filter won't refresh automatically. Have you tried the auto-filter?
This will refresh when you change the criteria
 
A

Alberto Ast

Thanks Patrick... I'll write a macro to update table then... I have a second
question regarding this filter...

What will be the best option to filter up to 50,000 rows... when I do this
filters it is not too slow to filter but takes too long to run when I clean
the filter....

I tried with Application.ScreenUpdating = False and then back to true and it
helps but not fast enough.
 
Top