I have a code to copy columns A:L. Paste the unique rows to columns O:Z. Somehow, the code is overwriting column W with values from column G.
Here is the code:
Dim lastCol As Long, lastRow As Long, r As Long, i As Long
Dim Rng As Range, Rng1 As Range, Rng2 As Range, Rng3 As...