+ Reply to Thread
Results 1 to 2 of 2

Dynamic Data Validation multiple lists

  1. #1
    Registered User
    Join Date
    06-08-2010
    Location
    Los Angeles,USA
    MS-Off Ver
    Excel 2003
    Posts
    12

    Dynamic Data Validation multiple lists

    I looking for some help with dynamic data validation. I have 3 cells E8-E10. In E8 i'm using a drop down list for Yes or No values. Based on the value E9 allows me to select from 2 different lists. "No" value displays 2 lists i can select from. Based on the selection E10 displays a list of countries which works perfectly. However when "Yes" value is selected in E8, it displays different lists which should drive the city list in E10.
    What i'm looking is that when E8=NO and E9 value, E10 displays a country list, but when E8=Yes and E9 value, E10 should display a city list.

    Appreciate the help!
    MK

  2. #2
    Forum Contributor
    Join Date
    05-16-2010
    Location
    UK
    MS-Off Ver
    2003 and 2007
    Posts
    252

    Re: Dynamic Data Validation multiple lists

    Could you post an example workbook?

+ 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