Macro Vlookup not sure which, but need help

[anelson02]

Ok so I will try to be short with what I need to do.

I have a spreadsheet attached here. Within that spreadsheet is two sheets, Quote # and Order #. The only thing that really matches between the two sheets is the Serial #

What I need is a macro or something that will allow me to press a button or something and preform the following task

I need to look in the Quote # sheet in Column D (Serial #) and match that to any number in the Order # sheet in column A. If a match is found, I need to copy the transaction number in Quote # sheet (column B) to Order # sheet column C.

Not sure how to do it, but I need to be able to just click a button or something and have it do the work if possible. Thanks in advance for any help on this