VBA Find Function from a List

[ph00086]

Hi,

I'm very new to VBA so apologies if i've missed something obvious.

I have a list of part numbers and a sheet full of requirements for those part numbers, i would like a macro that can search the requirements sheet for each part number in turn and then copy the value to another sheet.

Thanks for the help.

[abduljaleel.mca]

It would be very helpful if you send me the excel file in which you want to do this.