update information on sheet1 from sheet2

Hi Gurus:

I need a VBA code to help me update information on sheet1 from sheet2.
I have my sample file attached and a Pseudo code written.

Thanks and have a great day!

Chris


Pseudo Code:
1, For the first item(cell B2) in column B in sheet1, search a match from the whole column C in sheet2
2, Once the first match is found at cell Ci of sheet2, stop searching.
3, Copy the content from cell Hi of sheet2 to cell E2 of sheet1.
4, Repeat the above steps for cell B3,B4,B5.......

Aviate,
It would be easier and faster to search all values in sheet 1 of column B. Any reason why you want stop after the first search?

None of the values in column B match with any value in column C, so the return value is big NIL

Originally Posted by AB33

None of the values in column B match with any value in column C, so the return value is big NIL

That is just sample file, the actually file is much larger so there must be matches. Thanks.

Originally Posted by AB33

Aviate,
It would be easier and faster to search all values in sheet 1 of column B. Any reason why you want stop after the first search?

Hi ABB33:
Thanks for your response,
Because there are a lot same values in that column, keep searching makes no sense.
Thanks
Chris

Chris,
I have attached two codes. Try them and let me know how you progress.

Hi AB33:
Sorry for my delayed response as I only work on Firday afternoon.

The code works perfectlly and I appreciate your help!

Have a great weekend!

Chris

Chris,
You are welcome!
Glad to know one of the code has worked for you. It was partly a guess work