Removing duplicates

[AMunir]

Hi Guys,

Very first time using VBA - complete Newbie. I'm using the below code to basically organise and copy data into a monthly master data sheet. I would want to build in the control to prevent duplicate values to be posted in the master data with an error message. Appreciate your help

Sub Append_data()


    Range("A1").Select
    Selection.EntireRow.Delete
    Selection.CurrentRegion.Select
    Selection.Copy
    Workbooks.Open Filename:= _
        "C:\Users\amunir\Documents\Alghanim VBA\VBA\Orders.xlsx"
    Range("A1").Select
    Selection.End(xlDown).Select
'   Range("A3259").Select
    ActiveCell.Offset(1, 0).Range("A1").Select
    Selection.PasteSpecial Paste:=xlPasteValuesAndNumberFormats, Operation:= _
        xlNone, SkipBlanks:=False, Transpose:=False
       
    ActiveWindow.Close savechanges:=True
    Range("A1").Select
    Application.CutCopyMode = False


End Sub

 

[Joe4]

It appears that this seems to be a school/homework assignment that a lot of people are asking about.
There are 4 of you who all joined yesterday, all located in the same city, all asking similar questions:
https://www.mrexcel.com/forum/excel-...vba-excel.html
https://www.mrexcel.com/forum/excel-questions/1055776-vba-preventing-duplicates.html
https://www.mrexcel.com/forum/excel-questions/1055746-prevent-duplicate-data-using-vba.html

Note that while people may be willing to give you "hints" or point you in the right direction, please do not expect people to complete your homework assignments for you.