Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / New Users / August 2007

Tip: Looking for answers? Try searching our database.

Automatically Deleting a List from Another List

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
ddethomas - 21 Aug 2007 19:36 GMT
Hello There,

I'm new to these parts and I'm hoping someone can help me. I have a simple
email list of 4000 addresses (List A) and some are no good. I've made a
separate list (List B) of those and want to delete all of them from the
initial list (List A). Is there a way of doing this without doing it
manually? A formula of some sort? Thank you for your help.
Don Guillett - 21 Aug 2007 20:16 GMT
Look in the vba help index for FIND (FINDNEXT if more than one). Then a for
each loop

Signature

Don Guillett
Microsoft MVP Excel
SalesAid Software
dguillett1@austin.rr.com

> Hello There,
>
[quoted text clipped - 3 lines]
> initial list (List A). Is there a way of doing this without doing it
> manually? A formula of some sort? Thank you for your help.
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.