I have frequently made the mistake of defining the criteria range to include
the field name and maybe two cells below that. The problem is that the two
cells must both have the filter value or everything will show. Better,
define the criteria range to include just the cell with the field name and
one cell below it then put the filter value in that one cell.

In other words, you cannot have blank cells in the criteria range.

Tom

"Jon Lam" wrote:

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