Im currently using this VBA code that looks at values in column A in Sheet2 and if found it removes this value in column A in Sheet1.
So, on Sheet1 in column A I have:
Please Login or Register to view this content.
On Sheet2 in column A I have:
When I run the VBA, as a result I have White, Black, Orange, White, without a, b, c, d, as these values are in Sheet2.
But if I have these in Sheet1 in column A:
the code does not work properly.