Simple Vba to find a date

I'm a total noobie at VBA

I'm trying to get this working but am totally lost.

It should be simple.

I have attached sample data for you to look at as it's hard to explain my problem with out it.

Basically I have two sheets - Both contain items in column1 and dates in column2 - I'm trying to write a macro that cycle through the item codes on sheet1 and match them against sheet2 and copy across the first date that is > than the date on sheet1 from sheet2 into column3 on sheet1. (If no date is found it should move on)

Help please - You wizz should have this licked pretty quick.

Algeraist,

See the attached workbook for a solution using SUMPRODUCT.


Have a great day,
Stan