Microsoft Office Forums - View Single Post - Need help to create macro to find and replace if conditions are met

limsp · 04-17-2019, 07:36 AM

I need some help in creating vba/macro to find and replace if conditions are met.

PHP Code:


			
Col_A        Col_B        Col_C
aa            Depa        Depb
bb            Depa        Depc
bb            Depb        Depi
cc            Depc        Depj
cc            Depd        Depk
aa            Depc
aa            Deph
aa            Depj

Condiitions:
1. If any value in column b match any of the list in column C
2. and column a is "aa",
3. then replace "aa" with "yy"

Thanks very much for the help.