+ Reply to Thread
Results 1 to 2 of 2

Listbox of Unique Records populating another listbox

Hybrid View

  1. #1
    Registered User
    Join Date
    03-13-2007
    Posts
    8

    Listbox of Unique Records populating another listbox

    Hi All,

    I have a bit of a dilemma. I have data stored in 3 columns.

    Col one is countries - With Multiple Entries for Each Country.
    Col two is Cities - Each city in col1 country.
    Col three is codes - Each city has a code.

    What I would like to do is filter col 1 to a listbox of only unique records and populate a second listbox of cities in that country. I can use lookup vector to get the city code.

    Does this make sense to anyone?? Is this even possible.

    Attached is my workbook so far.

    Any help is greatly appreciated.

    2xs
    Attached Files Attached Files

  2. #2
    Forum Expert teylyn's Avatar
    Join Date
    10-28-2008
    Location
    New Zealand
    MS-Off Ver
    Excel 365 Insider Fast
    Posts
    11,374

    Re: Listbox of Unique Records populating another listbox

    Hi,

    you are working with data validation, not list boxes. You can create dependent data validation as described here

    http://www.contextures.com/xlDataVal02.html

    hope that helps

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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