software

i have my mailing list in excel in a long list of emails. each month when i
get unsubscribes i have to go through manually and find and delete. is there
a way that i can take the list of unsubscribers in one sheet and delete them
from my main list?

thank you

Only with some VBA code. The following code assumes you have your
master emails in a sheet called quot;Emailsquot; and the emails to
unsubscribe in a worksheet called quot;Unsubscribequot;. Change the
A1:A100 range to the range of cells on your quot;Unsubscribequot; sheet.Sub AAA()
Dim Rng As Range
Dim FoundCell As Range
For Each Rng In Worksheets(quot;Unsubscribequot;).Range(quot;A1:A100quot;)
Set FoundCell =
Worksheets(quot;Emailsquot;).Range(quot;A:Aquot;).Find(what:=Rng.T ext)
If Not FoundCell Is Nothing Then
FoundCell.EntireRow.Delete
End If
Next Rng
End Sub--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com
quot;jenniferquot; gt; wrote in message
...
gt;i have my mailing list in excel in a long list of emails. each
gt;month when i
gt; get unsubscribes i have to go through manually and find and
gt; delete. is there
gt; a way that i can take the list of unsubscribers in one sheet
gt; and delete them
gt; from my main list?
gt;
gt; thank you
goog grief that was quick! thank you very much although it is still all
sounding a bit greek to me. if it helps i sell paintings for a living so i
may have to get someone to translate this for me. i'm terrible at tech speak.

thank you so much though

jenni