Hello every one,

Im sorry if there was similar problem and it was solved.

I have a document with some parts specification and it is needed to find exact text and in nearby cell write that text code.

For example:
There are rail bracket position in excel document with different dimensions 40mm, 50mm, 56mm, every different rail bracket dimension have its own code.
40mm - 227373040
50mm - 227373050
56mm - 227373056

I need that macro find "rail bracket 40mm" and in left cell from that cell where are rail bracket put a code "227373040"
and for all dimension would made same.
Number Code Name
1 Rail Bracket 40mm
2 Rail Bracket 50mm
3 Rail Bracket 56mm

Could anyone help me with that?
Thank in advance.