The Data, AutoFilter and Data, Advanced Filter commands can be used to show
data rows that match criteria in place (by hiding non-matching rows of the
database). Advanced Filter can also be used to create a new list of just
the matching rows. If you are not familiar with these commands perhaps you
can experiment with them to see how they work. Then you can record a macro
as you do either type of filter to see the macro syntax. With the online
VBA Help you should be able to write a macro that creates the report you
want.

For more help with filtering you could look at the Contextures web site:

http://www.contextures.com/xladvfilter01.html

--
Jim Rech
Excel MVP