macro code for EXCEl

See more:

VBA

Somebody help in creating a macro for excel in VBA and the question is

Q. there are different values in Column A and a part of the string has to be matched searching all the rows of the column and if that matching is found in different cells than a value is pasted in the right of that cell.

for e.g. below there's a column A some Value contains characters "GB" so the cells in excel matching that part GB , there should be a text pasted in the right cell of the column B that matched in different cells.

COLUMN A COLUMN B
4253GB75 EMP
3297TC86 FIL
534GB768 EMP
3297TC87 FIL

somebody help me out in this, give me code in VBA