access-type query in excel 2007

[newyorkjoy]

Is there a way of filtering in excel 2007 where I can save that filter, give
it a name, and use it again, similar to a query in access?

 

[Dave F]

YOu could record a macro in which you perform the filter and then
attach that macro to a button...