• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

copy the unique values and visible content in a column

Marco1975

New Member
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 .
 

Attachments

  • example.xlsx
    13.4 KB · Views: 0
What about using an Advanced Filter
Then a sort
That could all be automated with some VBA

I'd also recommend instead of saying extract the Non-Hidden values
A better way to say it is extract the values where Oggetto=Paulo
 
Thanks Hui for the reply but I can't use Advanced Filter and pivot tables.
I'd like to automate with a macro vba...
 
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.
 

Attachments

  • example 2.xlsm
    18.9 KB · Views: 0
Back
Top