G'day Jimbo

Expanding on Biff's response, you can automate the process by using the code
at the link below.

http://www.rondebruin.nl/copy2.htm

It will filter, then copy your filtered ranged based on your criteria and
paste to a new worksheet for you.

attach the code to a Macro Button on your WS.

HTH
Mark.