Macros to find matching text on other sheet and to select an offset cell

Hey guys, any help on this macros would be appreciated. I've been stuck on it for 2 days.

I have two sheets:
Find Stock Symbols
Stock & Symbol Data

On the find stock symbols sheet, column B5 and downward will have many company names.
The macros will go through each company name and try to match the same company name on the other sheet "Stock & Symbol Data" (from range B2 downward).

When it finds a match, it should select the matched cell, then offset one cell to the left.
It should use this offset cell's value to equal the value in a corresponding cell in the "Find Stock Symbols" sheet in Column C.


(If it's confusing, please see the attached sample sheet.)
Company Name.xlsm

Please Login or Register  to view this content.

Thanks Patel45! It worked perfectly!

Originally Posted by patel45

Please Login or Register  to view this content.