+ Reply to Thread
Results 1 to 3 of 3

Remove 1 sheet of records from another sheet

  1. #1
    Registered User
    Join Date
    11-07-2014
    Location
    Netherlands
    MS-Off Ver
    2010
    Posts
    2

    Remove 1 sheet of records from another sheet

    Hi there!

    I just registered so I'm new here, and relatively new to Excel macro's as well. There's a work related excel issue that's been cracking my skull for a while now. I get this assignment in one form or another quite often but I can't figure out a foolproof solution.

    The situation:
    - I have a LongList of records containing e-mail addresses, names, zipcodes and so on
    - I have another ShortList of just e-mail addresses, that I know are also in the long list
    - I have to remove the ShortList's e-mail addresses and the associated rows of data from the LongList

    I searched around online and keep coming back to this macro. Supposedly, it loops through the LongList and checks if a record occurs on the ShortList. If it does, it deletes the entire row of data from the LongList. Have a look:

    Please Login or Register  to view this content.
    This one worked for me once, however I get mixed results ever since. Sometimes it seems to remove records from my LongList but after a double check, the addresses from the ShortList are still on the LongList (so it has removed some other records).

    While I sort of understand what each line of code does, I'm a bit confused about which sheet is the LongList and which one the ShortList in the above macro. Also, I'm not sure how to enter the ranges. In my case I need all of a column, not just the first 100, but I'm not sure about the syntax for that.

    Can anyone help out an excel newbie and tell me if the above macro is correct, or how I need to change it, or heck, even suggest an alternative? You'd really make my day! Thanks in advance.


    Bob

  2. #2
    Forum Expert Tinbendr's Avatar
    Join Date
    06-26-2012
    Location
    USA
    MS-Off Ver
    Office 2010
    Posts
    2,125

    Re: Remove 1 sheet of records from another sheet

    The same thing only different.

    Change sheet names as required.

    Please Login or Register  to view this content.
    David
    (*) Reputation points appreciated.

  3. #3
    Registered User
    Join Date
    11-07-2014
    Location
    Netherlands
    MS-Off Ver
    2010
    Posts
    2

    Re: Remove 1 sheet of records from another sheet

    Genius! Thank you so much!

    Sorry for taking a while to get back to this, but I've had some other prio's at work. This'll serve me for life ;-)

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 10
    Last Post: 05-06-2014, 11:53 AM
  2. Replies: 2
    Last Post: 12-20-2013, 01:09 PM
  3. Compare Sheet1 and Sheet 2 and Remove Matching Records from Sheet1
    By MotoDave in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 06-21-2013, 12:35 PM
  4. moving all correct records into one sheet and wrong records into one sheet
    By ramserp in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 11-19-2009, 05:31 AM
  5. [SOLVED] How do I remove or filter out duplicate records in a sheet?
    By geo in forum Excel General
    Replies: 4
    Last Post: 02-15-2006, 06:50 PM

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