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

aditya wrote:

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