Macro Help

[ryanparmstrong]

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

[shg]

How about just a formula?

http://www.contextures.com/xlFunctions02.html

[arlu1201]

Please take a moment to read the forum rules and then amend your thread title to something descriptive of your problem. Once you have done this please send me a PM and I will remove this request.

To change a Title on your post, click EDIT then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.