Advanced Filter process error msg

[Helen]

Let's try posting the question in this section and see if I get a response!
*****
I followed the instructions in Contextures for creating an advanced filter.
I want to copy the data to another worksheet.

When I click on OK, I get the following msg:
You can only copy filtered data to the active sheet.

I have been on both the worksheet with data and the empty worksheet when
clicking OK, with the same results.

When I tried the filter "in-place," it left me only the first row of data
.... which does NOT meet the set criteria. At least one row of data in the
full set does meet the criteria.

List Range = $A$2:$AP$291
Criteria Range = $AR$1:$AX$2

Any clues what I might be doing wrong?

 

[Helen]

Never mind. I stumbled across an answer from Ron Cordero back in 2006 that
helped.