PC Review


Reply
Thread Tools Rate Thread

Automatically Deleting a List from Another List

 
 
=?Utf-8?B?ZGRldGhvbWFz?=
Guest
Posts: n/a
 
      21st Aug 2007
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.
 
Reply With Quote
 
 
 
 
Don Guillett
Guest
Posts: n/a
 
      21st Aug 2007
Look in the vba help index for FIND (FINDNEXT if more than one). Then a for
each loop

--
Don Guillett
Microsoft MVP Excel
SalesAid Software
(E-Mail Removed)
"ddethomas" <(E-Mail Removed)> wrote in message
news:12B4F7F7-17F2-4031-8F6B-(E-Mail Removed)...
> 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.


 
Reply With Quote
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Automatically extend a list when adding a new data to another list JB Microsoft Excel Misc 0 25th Mar 2010 02:50 PM
produce list automatically from choice of drop down list David Microsoft Excel Misc 1 8th Mar 2010 07:15 PM
Code to automatically sort a list, each time that a new entry isadded to the bottom of the list Mike C Microsoft Excel Programming 5 13th Apr 2008 04:59 PM
Automatically Deleting a List from Another (Larger) List ddethomas@gmail.com Microsoft Excel Misc 2 21st Aug 2007 08:31 PM
Deleting Rows Automatically using a Text File List mirdonamy Microsoft Excel Misc 9 11th Jan 2006 11:11 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 01:10 AM.