The macro recorder is your friend. Record a macro while doing and then clean
it up. Assign to a button.
--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"sbailey" wrote in message
...
I create lists of numetic data, that I consistantly update.

I always use the same filter criteria. How can I save this criteria so I
can re-use.