Biff,

Thanks for your response. I don't know if I'm using a criteria range or
not - how do I set that up, and do I need to? I went through a more detailed
description of what I'm trying to accomplish in a response to ShaneDevonshire
if you'd like to read that.

Mark

"T. Valko" wrote:

it only wants to let me put the data in the active worksheet.
Is there a trick

Yes, sort of. Start the filter process from the destination sheet.

For example, if your data is on sheet1 and you want to extract some of it to
sheet2, start the process from sheet2.

Are you usng a criteria range? If you want to filter on Class = P...

On sheet2 use cells A1:A2 as the criteria range.

A1: Class
A2: ="=P"

--
Biff
Microsoft Excel MVP