copy the header along with your criteria to the criteria range

--
Don Guillett
SalesAid Software

"DP7" wrote in message
...
I think this can be done by advanced filter but I can't get it to work! I
want to filter my worksheet by 10 different criteria that are in the same
column. If it can be done with an advanced filter how would I set it up?
If
it can't be done using this advanced filter what are the other options I
have?

Thanks in advance