Replace cell value from another cell value in VBA

[neonehal]

I have an excel:

A	B	C
"ABC"."EF"	"MNO"	"YO"
"XYZ"."BCD"	"ABC"	"GO"
"MNO"."ABC"
"ABC"."JKL"

I want to check each column B in to column A. If B is matching with A then replace text of B into A with C.

Final Result will be:

A	B	C
"GO"."EF"	"MNO"	"YO"
"XYZ"."BCD"	"ABC"	"GO"
"YO"."GO"
"GO"."JKL"

Kindly help to achieve this using VBA. I tried writing VBA using Replace function but not able to replace cell with cell value.

[OllieB]

The following code requires adding Microsoft Scripting Runtime via Tools>References in order to use dictionaries

Please Login or Register  to view this content.

[watersev]

hi neonehal, much simpler option, please check attachment, press Run button

[neonehal]

The following code requires adding Microsoft Scripting Runtime via Tools>References in order to use dictionaries

Please Login or Register  to view this content.

it works!!!

Thanks Alot Man!!! You are awesome!!!

[neonehal]

Thanks Watersev!!!

Your code was pretty easy and simple to implement!!!