Sub tj()
Dim rng As Range: Set rng = Range("v4:v50")
Dim lr As Long
lr = GetLastRow(2, Sheets("sheet2"))
With Range("F" & lr + 9).Resize(rng.Rows.Count)
.Value = rng.Value
.RemoveDuplicates Columns:=1, Header:=xlNo
.Sort key1:=Range("F" & lr + 9), order1:=xlAscending, Header:=xlNo
End With
End Sub