get unique values from one column into new workbook:

PHOTO EMBED

Wed Sep 08 2021 06:05:17 GMT+0000 (UTC)

Saved by @Darkleech #vba

Sub SelectionToUniqueValuesInNewWB() 'To get unique values from one column into new workbook:
    Selection.Copy
    Workbooks.Add
    Range("A1").PasteSpecial xlPasteValues
    Range("A:A").RemoveDuplicates Columns:=1, Header:=xlNo
End Sub
content_copyCOPY