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 like this


023540
045789
020144.

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. Thanks for helping me with this challenge.