+ Reply to Thread
Results 1 to 2 of 2

Match Email ID Before Inserting

  1. #1
    Registered User
    Join Date
    11-20-2012
    Location
    Kolkata
    MS-Off Ver
    Excel 2010
    Posts
    34

    Match Email ID Before Inserting

    Hi All,

    I have 7101 email IDs in A1 in sheet 1. Now I want to insert New Email ID in Sheet2. I am going to create a user form and Before Inserting new email ID the user should check whether the email ID is present in Sheet1. if the email ID is present it shows me a msg box 'the email is already there'



    How do I do that?

  2. #2
    Forum Contributor
    Join Date
    08-02-2013
    Location
    Wageningen, The Netherlands
    MS-Off Ver
    Excel 2010
    Posts
    493

    Re: Match Email ID Before Inserting

    Like this:
    Say sheet2 A1 has the new email address in it
    Then type in B1: =if(countif(sheet1!a:a;sheet2!a1)>0;"the email is already there";"")

    Or if you want the fancy massage box, write a macro (I'm not sure exactly how)
    When I say semicolon, u say comma!

+ Reply to 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