Turn on the macro recorder. Use the filtering process I described
above. Turn off the macro recorder. Then you will have the VBA code
that can be rerun with a couple of clicks.

Hth,
Merjet