Results 1 to 8 of 8

Alert User of Duplicate Entry

Threaded View

  1. #1
    Forum Contributor
    Join Date
    04-02-2008
    Location
    Jacksonville Beach, Florida
    MS-Off Ver
    Microsoft Excel 2003 and 2010
    Posts
    264

    Alert User of Duplicate Entry

    I am looking to add to the begining the VBA below. The goal is for the code to first check if the data in cell A4 (on "Tracker" tab) is listed anywhere in column A on the "Store" tab and if there is a match, provide the user with a message that says "Already Entered" and stop the macro. If there is not a match, proceed... Help!

    Sub NameUpdate()
    
    Application.ScreenUpdating = False
    
    Range("A4").Select
    Selection.Copy
    Sheets("Store").Select
    Range("A2").End(xlDown).Offset(1, 0).Value = Range("A1")
    
    Sheets("Tracker").Select
    Range("A8").Select
    Selection.Copy
    Sheets("Store").Select
    Range("B2").End(xlDown).Offset(1, 0).Value = Range("B1")
    
    Sheets("Tracker").Select
    Range("AL1:AL2").Select
    Selection.Copy
    Range("A4:A5").Select
    ActiveSheet.Paste
    
    Sheets("Tracker").Select
    Range("AL1:AL2").Select
    Selection.Copy
    Range("A8:A9").Select
    ActiveSheet.Paste
    
    Range("H1").Select
    ActiveCell.FormulaR1C1 = "1"
    Range("W3").Select
    ActiveCell.FormulaR1C1 = "1"
    Range("A1").Select
    
    ActiveWorkbook.Save
        
    Application.ScreenUpdating = True
    End Sub
    Last edited by dreicer_Jarr; 02-16-2011 at 12:56 AM.
    ______________________________________
    "Vision without Execution is a Hallucination"
    Edison

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