Refresh Autofilter
Does anyone know if there is a way to "refresh" the AutoFilter with one click (even a short-cut key would work for me)?
Basically, I have filters set on a spreadsheet, and I am filling items, and I would like the filter rules to apply to all the new data periodically.
Thanks!!
Last edited by kellyfspringer; 07-12-2009 at 07:09 PM.
Take a look here for a possible solution.
Refresh AutoFilter Automatically
http://www.ozgrid.com/forum/showthread.php?t=59917
Thank you, not exactly what I was looking for, though. I don't need it to happen every single time a cell is changed, I just wanted to know if a "one-click" button already existed. like the "show all" button.
Thanks, though!
Hi,
There is an option in Excel 2007 Menu. Data > Sort & Filter > Reapply
which will refresh the auto filter data in a single click.
Hope this help you.
Regards,
guru
well say you have auto filter on cols a.b.c.d and filtering on y/n in col d
or even
Please Login or Register to view this content.
assign to a buttonPlease Login or Register to view this content.
"Unless otherwise stated all my comments are directed at OP"
Mojito connoisseur and now happily retired
where does code go ?
look here
how to insert code
how to enter array formula
why use -- in sumproduct
recommended reading
wiki Mojito
how to say no convincingly
most important thing you need
Martin Wilson: SPV
and RSMBC
Thanks for all the great ideas guys!
My problem is that my criteria isn't always the same.
No worries... just looking for the moon, I guess
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks