Results 1 to 7 of 7

Delete rows from Sheet1 with same email field in Sheet2

Threaded View

  1. #1
    Registered User
    Join Date
    07-20-2011
    Location
    Kerala, India
    MS-Off Ver
    Excel 2013
    Posts
    93

    Thumbs up Delete rows from Sheet1 with same email field in Sheet2

    Hi! I use Windows7 with MS Office Professional Plus 2010

    I have attached a sample Excel file with
    Sheet1: Containing data from a lead collections software
    Sheet2 Column A: some common email domains


    Sheet1: Column B - contains Email ID's of the leads collected

    My requirement is to remove all the common email domain( listed in Sheet2 Column A) ROWS from Sheet1
    The results can either be edited on the same Sheet1 or on a Fresh Sheet.

    The result sheet should not contain any rows with "common email domains"
    As in Sheet3: (which I have done manually using filters)

    Thank you
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Mcro to Delete Rows on Sheet1 where Ref No on Sheet2 is the same
    By Howardc1001 in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 12-17-2020, 02:37 AM
  2. extractin data from sheet1 into sheet2+adding&deleting rows in sheet1
    By xxl2953 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 05-18-2016, 05:05 AM
  3. Move rows from sheet1 to sheet2 based on a field value
    By ivanka2000 in forum Excel Programming / VBA / Macros
    Replies: 14
    Last Post: 02-19-2016, 08:15 AM
  4. Delete rows based on matching dates in Sheet1 Column A with date in Sheet2 Cell K1
    By robertaw in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 11-24-2015, 02:30 PM
  5. Need a macro to delete data on sheet2, copy data from sheet1 to sheet2
    By noorie007 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 06-03-2014, 02:32 PM
  6. Replies: 6
    Last Post: 07-25-2013, 02:58 PM
  7. Delete from Sheet1 the rows that are also on Sheet2
    By email4kh in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 04-28-2010, 10:48 AM

Tags for this Thread

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