autofilter update automatically
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? |
autofilter update 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 |
All times are GMT +1. The time now is 12:17 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com