comparing lists

  • Thread starter Thread starter bill22
  • Start date Start date
B

bill22

I have a data base of email addresses of people who have requested to
receive info from our publication. Each month, our ISP sends me a list
of email addresses of people who have chosen to be removed from that
list.

What is a good way to have Excel compare the two lists in order to
delete or even better highlight/flag the addresses of the people who
request to be removed?

Bill
 
I help with a similar task:

1. original list is in column A
2. put deletions in column B
3. enter and run :

Sub cleanout()
Dim s As String
For i = 1 To 500
If IsEmpty(Cells(i, 2).Value) Then
Else
s = Cells(i, 2).Value
Range("A:A").Replace What:=s, Replacement:=""
End If
Next
End Sub

if you have more than 500 deletions, then update the code.

Cells will be just blanked-out, sort to remove the blank cells, if desired.
 
Sorry, I missed your line that says the replaced cells would be blank. I
changed the "" to "removed" to help keep it visual.

Wonder if you can help me with something that has popped up in the
meantime... Something called XY chart labeler keeps opening up with
several windows. How do I disable this or at least get it to keep
opening up?

Appreciated very much your help with the list problem.
 
Back
Top