Hello everyone:

I need to compare tow data sheets. The first one is aprox 300 cells
long
and have this format:

001254 Driver Side Rear Discharge
204451 AirInlet Lower Step of Cab

and go on.

The second one have numbers, aprox 5000 rows like this


023540
045789
020144 etc.

I need a macro that compare the first sheet to the second one, and when
the same number is found from the first one on the second one
create a third sheet with the common number on the first one plus the
description. It is for exel 2000. Thanks for helping me with this
challenge.


--
Firevic
------------------------------------------------------------------------
Firevic's Profile: http://www.excelforum.com/member.php...o&userid=23955
View this thread: http://www.excelforum.com/showthread...hreadid=375851