I haven't made a macro or troubleshot one in a few years.

I have 2 sheets with the A column on both being a product code field.

I need a macro that will look at SHEET2 column A and when it finds a match in SHEET1 column A to copy a field from that row in SHEET1 Column Q into SHEET2 Column B

Basically, SHEET1 is all the products a company offers. SHEET2 are the products mine offers from that larger list in SHEET1. Column Q in SHEET1 is the stock status of that item and I need to correct stocks to show in Column B of SHEET2.

How would I do this, or is there already a macro or piece of code that I can use?

Thanks,
Ryan Armstrong