Find and replace string if value find in column

Hi all,

I have two sheets (Sheet1 and Sheet2).

I would like a VBA to look at values in column A in Sheet2 and if found it replace with any other text or remove this value in column A in Sheet1.

So as a result I would have White, Black, Orange, White, without a, b, c, d, as these values are in Sheet2.


Sheet1
Column A
a white
b black
d white
c orange


Sheet2
Column A
a
b
d
c




Thanks a lot!

only exact match should be removed/replaced. In this case "a", "b", "c", "d" are going to be replaced in Sheet1 as they are in Sheet2. The "a" in the middle of orange is not going to be replaced, as "orange" is not in Sheet2.

Cheers