VBA: Remove duplicates from closed workbook

[lunatu]

Hi,

Any ideas how to create a macro that will remove duplicates from a closed workbook?

Im copying rows from workbook to another workbook which is closed and at the same I need to remove duplicates.

The range in use is A:N and the duplicate values to be checked is in column N.

The macro to copy rows I have already solved.

Any ideas how to solve this?
Thanks in advance

 

[6StringJazzer]

Please show the code you already have. It's not clear what you mean by "closed workbook" since I am unaware of any way to write data to a workbook without opening it. Maybe you mean that the workbook starts out closed and your code opens it.

One strategy for this is to use Advanced Filter to get a list of unique values. Or the code could just do it by brute force. But there is not not enough detail in your description to give you code specific to your situation.

 

[lunatu]

Hi,

this is the macro Im using for copying:

Sub MasterData()
Dim LastRow As Integer, i As Integer, erow As Integer
LastRow = ActiveSheet.Range("A" & Rows.Count).End(xlUp).Row
For i = 2 To LastRow
If Cells(i, 15).Value = "Yes" Then
Range(Cells(i, 1), Cells(i, 14)).Select
Selection.Copy
Workbooks.Open Filename:="C:\Master.xlsx"

Worksheets("Changes").Select
erow = ActiveSheet.Cells(Rows.Count, 1).End(xlUp).Offset(1, 0).Row
ActiveSheet.Cells(erow, 1).Select
ActiveSheet.Paste
ActiveWorkbook.Save
ActiveWorkbook.Close
Application.CutCopyMode = False
End If
Next i
End Sub

And it currently copies all rows with condition "Yes", but some of the rows already exists in master Excel so I need to remove duplicates at the same time.