comparing lists
 

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

comparing lists
 

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

comparing lists
 

Sorry, I am a bit of a novice. Can you expand on your explaination a
little (a lot)?

Gary''s Student Wrote:
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




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

comparing lists
 

The text from Sub thru End Sub is a macro. You don't need to do any
programming, just /copy/paste. See:

http://www.mvps.org/dmcritchie/excel/getstarted.htm

for instructionson installing and using macros

--
Gary's Student


"bill22" wrote:


Sorry, I am a bit of a novice. Can you expand on your explaination a
little (a lot)?

Gary''s Student Wrote:
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




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

comparing lists
 

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.


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

comparing lists
 

You are very welcome.

Sorry I can't help you with chart stuff, I know nothing about them.

There is a discussion group specifically for charts, try opening a new post
the

http://www.microsoft.com/office/comm...a ng=en&cr=US

--
Gary''s Student


"bill22" wrote:


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.


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