About an hour and a half ago, Debra Dalgleish told Wayne this in much more
detail:

An AutoFilter dropdown list will only show 1000 entries. If your column
has more than 1000 unique items, they can be filtered, but they can't
all be displayed in the dropdown list.

To AutoFilter for an item that doesn't appear in the dropdown list, you
can choose Custom from the dropdown list, and type the criteria. Also,
there are a couple of workarounds he

http://www.contextures.com/xlautofilter02.html#Limits

-------------------------------------------

Apparently that was not sufficient to prevent this question or your less
detailed response.

Hopefully I have explained more clearly.

Anyway, It might be more efficient to copy all the data at once using an
Advance filter and using his sheet with the 119 values as a criteria range.
then it would only take a single command to copy the actual data. I will
let you give him that code.



--
Regards,
Tom Ogilvy


"JMay" wrote in message
...
I think the 1,000 limit has to do with the count of the items appearing in
the "dropdown" box of an auto-filtered column header -

"wayne" wrote in message
:

Tom - I lloked at that link but it is my understanding that the
autofilter
has a limit of 1000 records.- am I not understanding what you are
saying???
thanks

Wayne

"Tom Ogilvy" wrote:

I gave you a link to Ron de Bruin's site that should fix you up.


--
Regards,
Tom Ogilvy


"wayne" wrote in message
...


Tom-

I will try to clarify my question....


Worksheet 1 has 119 records that have equip ids in column A sorted in
ascending order.

Worksheet 2 has 50,000 records that have equip ids in column A but
not
sorted.

I'm looking for a way to compare to lookup all occurrences of the
records
in
worksheet 1 that are matched(equip ids) in worksheet 2 and when I
find a
match I want to copy columns b thru d from worksheet 2 to a new
worksheet.

Can you offer any advice on how to accomplish this. Thanks

Wayne