Hi,
Could you please help me to find the VBA code for below scenario.
I have data in Column A, ColumnB, ColumnC.
Check code #1234 in ColumnA. If it finds, 5678 should return in corresponding cells for Column C.
Else
Check code #ABCD in ColumnA. If it finds, EFGH should return in corresponding cells for Column C.
Detailed Explanation :
Find "ABCDE" in ColumnA (Example Range from A20 to A3000) then replace it with "FGHIJ" as a result in column C.Means, if "ABCDE" present in ColumnA of Cell A30 then result "FGHIJ" return to Column C of cell C30. ABCDE occurs in more than onetime in columnA
Regards,
Sri