autofilter update automatically

[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?

 

[Dave Peterson]

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