Find Duplicates, 2 Columns, Different Worksheets

[Admin]

Hi

replace

.Range("a" & .Rows.Count).End(xlUp).Offset(1).Resize(n, UBound(k, 2)) = k

with

.Range("a" & .Rows.Count).End(xlUp).Offset(1).Resize(n, 10) = k

[ghendi]

Hey Admin,

Just gave it a shot and all is looking well.

Could you please add to the code the ability to add to Column K in the master sheet the value 0 when it is copied over?

Also, can you please confirm that both Column D and E are being checked in order to find the duplicate rows? I'm just worried 2 members with the same street address but different unit numbers will be considered duplicates.

Thank you!!

-Amit