Automatic List

[DanWo]

In the 1st Sheet Column A, I introduce list of articles (text).
I would like to know if there is a way to create automaticaly in Sheet 2 Column A a list of all articles sorted alphabeticaly ; Same articles may appear several time in Sheet1 but ONLY once in Sheet2.

 

[Zathras]

Use Data / Filter / Advanced Filter... to get a list with each article listed only once: Start on Sheet2 and take options for "Copy to another location" and "Unique records only" Click in the field for the "List range" and select the range with the mouse (from Sheet1) then click in the field "Copy to" and select cell A1 (from sheet2). Click OK.

Then sort the resulting list.

If you want a macro, use the recorder.