Advanced Filter process error msg


H

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?
 
Ad

Advertisements

H

Helen

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top