Advance Filter

[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

 

[Peo Sjoblom]

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