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

On Aug 2, 9:40 am, newyorkjoy
wrote:
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?
--
newyorkjoy
thanks for the help!