Hi Jeremy,

Further to John's suggestion, if you need
a macro solution, try turning on the macro
recorder while you follow the
recommended Advanced Filter steps.

This will provide you with base code
which may be edited to provide a generic
routine.

If you expereience difficulties with such
editing, post your code and indicate the
specific problems.

If, however, a VBA solution is not
mandatory, consider downloading
Ron de Bruin's excellent EasyFilter Add-In,
which may be downloaded, as freeware,
at:

EasyFilter Add-In
http://www.rondebruin.nl/easyfilter.htm



---
Regards.
Norman