Hi,
I was looking for a macro that copy from a column unique values; the values must be copied only those cells visible and placed in alphabetical order in a new column.
I can't use Pivot Tables .
Thank you.
Enclose sample files .
Hui but if the columns are not adjacent how it changed the macro ??
for example " object " begins in C8 and " district " in O8 ; C8 between O8 and there are other columns filled . I'm sorry but I had not thought to specify the example.