How to search in one column, and replace in the other column if fo
I have multiple data in Column A, these data have a value in column B, I am
looking at a way (via VBA) to go from A1:A100 looking for curtain names (say
€śAdnan€ť, €śJohn Smith€ť,€ťJohn Doe€ť) and change their value in column B to sy
for Adnan 10, for John Smith 25, and for John Doe = 65 wherever they are
(they exist in more then two places).
These values could be text, numbers, date or currency.
Thank you,
Adnan
|