Closed Thread
Results 1 to 2 of 2

Sort/Remove Script?

  1. #1
    Registered User
    Join Date
    07-01-2009
    Location
    USA
    MS-Off Ver
    Excel 2007
    Posts
    9

    Red face Sort/Remove Script?

    Hey guys, I'm from a Laptop Repair Company. Sorry to barge in here and ask for help randomly, but any suggestions would be greatly greatly appreciated. I post mostly on Actionscript forums to help others using AS3.0, so if you have a question there I could definitely help you lol

    I have 2 .xls documents with customer contact information. One has a list of old contacts I need to remove which is about 3k this list contains only email addresses. The other contains the full list of Customers this list is about 11k this contains everything from first/last name to billing and email addresses.

    My goal is to double check to see which addresses are just typos and which are non-working.

    I will need to go through the list line by line but better to only go through 3000 than 11000. So, I need to somehow remove all of the good addresses from the full list using the bad address list which is only 3k long.

    Any suggestions on where to start?

    ~Rossco

  2. #2
    Valued Forum Contributor mudraker's Avatar
    Join Date
    11-10-2003
    Location
    Melbourne, Australia
    Posts
    3,983

    Re: Sort/Remove Script?

    A good starting spot is the Forum Rules

    This is a duplicate post and as such does not comply with Rule 5 of our forum rules. This thread will now be closed, you may continue in your other thread.

    Thread Closed.
    Please Read Forum Rules Before Posting
    Wrap VBA code by selecting the code and clicking the # icon or Read This
    How To Cross Post politely

    Top Excel links for beginners to Experts

    If you are pleased with a member's answer then use the Scales icon to rate it
    If my reply has assisted or failed to assist you I welcome your Feedback.

Closed Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1