autofilter update automatically

  • Thread starter Thread starter aditya
  • Start date Start date
A

aditya

i have applied autofilter to a datasheet. After that, i enter data in same
sheet.Is there any way that earlier applied filter updates automatically?
 
You could record a macro when you do it manually and play back that macro.

But if you're filtering on the fly by lots of different fields and values, then
I don't think it's worth the trouble.

I'd do it manually.

But if you're running xl2003 or below, I would add a "show all" icon to my
favorite toolbar:

Tools|Customize|Commands tab|data category
Drag the "Show All" (and maybe autofilter) icon to a t
 
Back
Top