Hi I hope someone can help me as this is really starting to bother me to the point of me wanting to throw the laptop out the window.

I have two sheets of data.

Sheet A contains over 2000 rows of product I stock in a online shop.
Sheet B Contains over 5000 rows of product that my supplier stocks, including one column that I am desperately after that is not in Sheet A

In both sheets there is a unique field.

I want to run a command that will search Sheet B for the unique filed that is in Both Sheets A & B and copy the data from Sheet B and place in a new cell against the unique field in Sheet A.

I am really hoping for this to be done automatically rather then me manually typing the the data in myself.

I really hope this makes sense.