Just start today learn VBA

[Fariros]

Hi

I want to past a data to another file using macro without any duplication

this below is past without considering any duplication

Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
:=False, Transpose:=False
ActiveWindow.Close savechanges:=True
Application.CutCopyMode = False
Range("A1").Select
End Sub

Regards,

 

[Joe4]

Welcome to the Board!

Looks like you got that code from using the Macro Recorder. Just continue doing that, and use Excel's built-in "Remove Duplicates" functionality to remove the duplicates after your copy and paste.