Problem: Copying data from one sheet to the other (Advanced).

Guys I have a challanging task that I need help with.

Basically I have two sheets:
Sheet 1 - Sheet 2

I need to grab the first item on sheet 1 and compare it to an array of items in sheet 2. Once that item is found, I need to grab the adjacent column item of sheet 1's currently compared to and read item.

After which pasting that copied item into sheet 1's item range and repeating it for the next row.

Heres a logical flow processes to make it clearer:

1. If sheet 1 x , is equal to sheet 2 x,
then copy sheet 2 y (the column item to the right of sheet 2's x)

2. Paste Sheet 2 y into Sheet 1 y column
3. Move down a row and repeat the process till you reach " "

End.

I need help in programming this. Please do not hesitate to ask me further if something is not clear.

Cheers Guru's.