Hi Peo,

Thanks for your reply. I'm a bit uncertain as to what your question is
pertaining to, but I'll try to answer it correctly. My criteria is the area
that was set up to type in the search values. So the headers on the criteria
table are the same as those on the data list. Then I put three spaces
between the header of the criteria area and the headers of the data list, as
suggested by the Excel Help window.

If your question was regarding the input that I was putting in, then it
varies a bit. I was trying to have it set up so I could filter by name for
instance, or by the area in which they work.

If criteria, you meant function, then I wanted to create an excel database
so that if I want to look for a specific person, or for people within a
specific region, then I could do so by an advanced filter. I could use an
autofilter, but I wanted to copy the data onto a separate worksheet as well
because too much data in one place would clutter the screen.

I hope one of these explanations hit upon your question.

"Peo Sjoblom" wrote:

What's your criteria?

--


Regards,


Peo Sjoblom

"Jon Lam" <Jon wrote in message
...
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