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.


--
Gary''s Student


"bill22" wrote:


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


--
bill22
------------------------------------------------------------------------
bill22's Profile: http://www.excelforum.com/member.php...o&userid=35563
View this thread: http://www.excelforum.com/showthread...hreadid=553196