H
Helen
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 does meet
the criteria.
List Range = $A$2:$AP$291
Criteria Range = $AR$1:$AX$2
Any clues what I might be doing wrong?
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 does meet
the criteria.
List Range = $A$2:$AP$291
Criteria Range = $AR$1:$AX$2
Any clues what I might be doing wrong?