Hi...I would like a list of values in a column in worksheet A to be created from unique values in column B from worksheet B. Values in this can be the same for many rows so I only want unique values. In worksheet I want a drop down list that a user picks.
Can anyone help with this please? Thanks
Hello fusion007,
This macro will return an array (single column) of unique values that are sorted.
Please Login or Register to view this content.
Macro Example
Change the worksheet names and ranges to what you are using. For the destination range (DstRng), you only need to specify the first cell of the list.
Please Login or Register to view this content.
Sincerely,
Leith Ross
Remember To Do the Following....
1. Use code tags. Place [CODE] before the first line of code and [/CODE] after the last line of code.2. Thank those who have helped you by clicking the Starbelow the post.
3. Please mark your post [SOLVED] if it has been answered satisfactorily.
Old Scottish Proverb...
Luathaid gu deanamh maille! (Rushing causes delays!)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks