Hi, So I have 3 Columns in an Excel Spread Sheet
Column A contains a list of values
Column B contains a list of values that may or may not be present in Column A
Column C has equal number of values as column A and the values correspond to each other
Now I need to remove ALL values from Column A that are in Column B
Ex.
Column A has
A
B
C
D
E
F
G
Column B has
B
C
Column C has
1
2
3
4
5
6
7
the resultant is Column A
A
D
E
F
G
Column B
B
C
Column C
1
2
3
4
5
6
7
this is done through this macro:
Sub TryMe()
Dim rRangeA As Range
Dim rRangeB As Range
Dim rCell As Range
Set rRangeA = Range("A1", Range("A65536").End(xlUp))
Set rRangeB = Range("B1", Range("B65536").End(xlUp))
For Each rCell In rRangeA
If WorksheetFunction.CountIf(rRangeB, rCell) > 0 Then
rCell.Delete
End If
Next rCell
End Sub
Now what i want to do is have this macro simutanously delete values from Column C as well
This means Column C should be
1
4
5
6
7
Any help is appreciated, im new to this, using Excel 2003.
Bookmarks