#1
|
|||
|
|||
Need help to create macro to find and replace if conditions are met
I need some help in creating vba/macro to find and replace if conditions are met.
PHP Code:
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. |
#2
|
||||
|
||||
Do you need a macro?
In row 2 of any column beyond column C: Code:
=IF(AND(A2="aa",ISNUMBER(MATCH(B2,$C$1:$C$5,0))),"yy",A2) Then copy|paste-special values over column A. |
|
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 |