Hi. I'm having a problem that I need help with. Here it is.

I have two columns of data. Each contains a 1 to 3 digit code. I need to compare column A to column B and if a code in A = a code in B, I need the entire row that intersects the cell in column A to be removed. Let me give the example:

(The information in Column B is in a separate worksheet but in the same work book.)

Worksheet 1 Worksheet 2
A B C D A
1 CL random data numbers 1 DBA
2 BC random data numbers 2 BL
3 DLB random data numbers 3 CL
4 ABA random data numbers 4 ST

Now what I've been trying to do, is have Column A in Sheet1 compare to Column A in sheet 2, and if the cells are equal (CL = CL), then remove the entire 'CL' containing row in worksheet 1.

I've tried in vein to solve this. Can anyone help please?