+ Reply to Thread
Results 1 to 3 of 3

How to use a column in one workbook to delete rows with duplicates in a different workbook

Hybrid View

JPCrow How to use a column in one... 08-07-2017, 01:16 PM
FDibbins Re: How to use a column in... 08-07-2017, 01:27 PM
JPCrow Re: How to use a column in... 08-07-2017, 02:37 PM
  1. #1
    Registered User
    Join Date
    07-01-2008
    Location
    texas
    Posts
    7

    How to use a column in one workbook to delete rows with duplicates in a different workbook

    Good morning,

    I have a list of first name, last name, email address, all in one excel workbook

    I have sent the people on this list emails, and have information about which addresses bounced for one reason or another, this list of email addresses is in another workbook

    I would like to remove all rows in the master email list that contain a matching email address from the email_bounced list, so I don't send email to addresses I know are bad,

    What is the simplest way to remove rows with bad emails from the master list?

    Thanks in advance!

  2. #2
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    53,049

    Re: How to use a column in one workbook to delete rows with duplicates in a different work

    You wont be able to do this with formulas, you will need VBA, so I will move this thread to that forum
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford

  3. #3
    Registered User
    Join Date
    07-01-2008
    Location
    texas
    Posts
    7

    Re: How to use a column in one workbook to delete rows with duplicates in a different work

    Thank you FD

+ 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. Merge 3 worksheets into 1 workbook and delete duplicates
    By LAConsulting1 in forum Excel General
    Replies: 5
    Last Post: 10-06-2015, 06:52 PM
  2. Fill Color for Duplicates Across all Sheets in Workbook in Column A
    By mikemorabito in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 01-24-2014, 01:26 PM
  3. How to efficiently delete entire rows based on duplicates in one column
    By HughManatee in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 09-16-2013, 06:53 PM
  4. Delete rows where column A has duplicates based on values in Column B
    By rajakumar.g@tcs.com in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 08-08-2013, 08:45 AM
  5. [SOLVED] VBA copy rows from a workbook and paste in the first available column of another workbook
    By rjnc in forum Excel Programming / VBA / Macros
    Replies: 16
    Last Post: 10-15-2012, 10:21 AM
  6. Export rows to another workbook but check for duplicates
    By revenge4ash89 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-11-2012, 06:43 PM
  7. Copy values(rows & column) from one workbook from Another workbook
    By ananthakumar.e in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-05-2008, 09:33 AM

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