Advance Filter

  • Thread starter Thread starter Kay
  • Start date Start date
K

Kay

I tried to use the advance filter to filter information by
using 2 separte worksheets. I opened the Advance Filter,
selected Filter the list, in-place. In the List range:
field I entered the worksheet name and column (All!$E:$E),
from the worksheet with all the data. In the Criteria
range: field I entered worksheet name and cells with
criteria to filter (Criteria!$A$1:$A$7). I was able to
filter this information once. Since then either Excel
shuts down or nothing is filtered.

I've tried to do it on the same worksheet based on the
help instructions and nothing is filtered.

Please Help!

Thanks, Kay
 
Name the criteria range instead (insert>name>define)

MyCriteria

=Criteria!$A$1:$A$7

then in the criteria range in the dialogue box when you apply the filter use

=MyCriteria
 
Back
Top