Results 1 to 10 of 10

Create sorted list based on longer, unsorted source

Threaded View

  1. #1
    Registered User
    Join Date
    01-29-2013
    Location
    The Netherlands
    MS-Off Ver
    2016 x64
    Posts
    48

    Create sorted list based on longer, unsorted source

    Hi,

    I have a workbook (simple version attached) in which I have a source worksheet that contains an unsorted list of values (approx 400 lines). In a second worksheet I want to use a list (data validation) that only contains a selection of the values in the source worksheet.

    the workbook:
    3 worksheets: Source (1), Lists (2) and Second (3)
    Source: source list and some extra working columns to help me determine which values I want to have in the list. The code to update the list is only triggered when there is a change in the source list.
    List: hidden ws that is used to maken the new (sorted) list
    Second: any other ws in which I want to use the sorted list as a dropdown menu.

    my question:
    is there a way to make the code more efficient?
    how can I sort the new list and have the duplicates and blanks removed?

    thanks

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Depenedent dropdown list to work even if source data is unsorted
    By kosherboy in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 12-31-2015, 09:55 AM
  2. Create List based on TODAY() and IF value is < X on source table
    By Flyinace2000 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 11-12-2012, 05:40 AM
  3. macro to generate sorted table from unsorted list?
    By JGCA in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 05-14-2009, 11:36 AM
  4. Replies: 4
    Last Post: 09-04-2008, 09:51 AM
  5. [SOLVED] how to create a sorted summary list of counted species
    By pak in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 04-20-2006, 07:15 PM
  6. [SOLVED] how to create a sorted summary list of counted species
    By kellerp.l@gmail.com in forum Excel General
    Replies: 1
    Last Post: 04-20-2006, 06:21 PM
  7. How to select sorted data listed under an unsorted grouping?
    By Joe R. in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 12-22-2005, 10:20 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1