Hi every one,

Please help vba/excel newbie!

I have 3 sheets with columns SKU and Quantity.
Sheet1 is raw data. Sheet2 is in house stock and Sheet3 is outside stock.

What I need is to loop through the rows in sheet1 and check if the SKU
exists in Sheet2 if not copy the row into Sheet3.

The problem is that the SKUs in Sheet2 (the one I'm matching against) change
all the time so I can't hard code them.

Thanks in advance for any advice!