Please refer to attached excel sheet.
I need a VB Macro to perform following task..
Sheet1 column 1 shows Company names....some companies listed multiple times
From here i wanted to create alphabetically Company names listed once...in Column 2
Let me know if you have any questions.
Looking forward for the solutions and always appreciate your help.
Thank you
Riz Momin
if I understant u properly u wanna get unique values in column B.... so u can use advanced filter option...
http://office.microsoft.com/en-us/excel/HP100739431033.aspx"]See how to get unique values with advanced filter[/URL]
Люди, питающие благие намерения, как раз и становятся чудовищами.
Regards, ?Born in USSR?
Vusal M Dadashev
Baku, Azerbaijan
No ...
First it needs to delete all blank rows.
Then delete duplicate company names ( 1 entry stays)
Then sort Alphabetically...
The above needs to be done thru Macro...so please help
Thank U
Riz
Ok. Try this Macro
Please Login or Register to view this content.
This works great! and solve my problem.
Thanks a lot...
Riz Momin
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks