You will need to use advanced filter. This will allow you two set you
criteria for a determined array.

some info her
http://www.contextures.com/xladvfilter01.html

just remember that the headings need to be the same i.e your dat
called names then the advanced filter array also needs to have th
title names

--
Message posted from http://www.ExcelForum.com