Need help to create macro to find and replace if conditions are met

limsp · #1 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.

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Find and Replace Macro Need	djpemberton	Word VBA	2	05-04-2016 07:53 PM
Looking for code to create a macro that prompts user to enter text, then does a find/replace.	sfvegas	PowerPoint	0	01-08-2016 02:22 AM
Find and Replace Macro	amparete13	PowerPoint	3	03-11-2014 05:29 AM
macro or find/replace	JamesVenhaus	Word	2	02-27-2012 03:34 PM
Find and Replace Macro - A Better Way	Tribos	Word VBA	0	10-08-2008 03:22 AM