i have data in sheet1 i would transfer data just non duplicated to sheet 2 i try with this code but show me error " object required"
and this is my code
Public Sub SumDuplicateData()
Dim Srch As Range
Sheet2.Range("A2:G100").Value = Empty
For I = 2 To...