In the Extract range (Copy To), enter the headings that you want to extract.
In the criteria area, use the headings and criteria that you need.

When you run the Advanced Filter, select the entire table as the List range.
Select the headings and criteria cells as the Criteria range.
Select the Extract headings as the Copy To range.


Yvette wrote:
I have tried using the advance filter unsuccessfully. the seven columns i
need to filter are not consecutive. any tips on filtering independant
columns?


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html