Hi Everyone,

I'm currently using Excel 2002. I have a list of names, addresses, phone
numbers and other info. I was trying to make it so that when I input a
search criteria, I could get back a result or a list of results depending on
the input. Access might be a better choice to use for long lists, but I
thought that if I were using Excel, I could possibly use an Advanced Filter
to do something like that.

I have the criterion space, the list, and the place I want to copy the
results to set up as the office help stated, but everytime I try to run the
filter, it doesn't seem to work. If I did the "copy to a new location"
option, it ends up copying the entire list over. For list, I'm using the
data I want to filter, and for criteria, I've highlighted the "criteria" area.

What am I doing wrong? I would appreciate any help I could get. Thanks in
advance.

- Jonathan