Results 1 to 18 of 18

Dependent Drop down list with DEPENDENT DEFAULT VALUE

Threaded View

  1. #1
    Registered User
    Join Date
    01-22-2010
    Location
    Ottawa, ON
    MS-Off Ver
    Excel 2007
    Posts
    5

    Dependent Drop down list with DEPENDENT DEFAULT VALUE

    Hello, all
    It must be pretty simple to do it but I'm lost..

    Situation:
    I have two drop down lists 1) Country and 2) States/province

    Country has list: [US, Canada]

    If "US" is selected, [Arizona ,Florida, NewYork] is listed in the 2nd drop down list
    If "Canada" is selected, [Alberta, Ontario, Quebec] is listed in the 2nd drop down list

    Scenario:
    First, I select "US" and choose the states to "Florida"
    Next I change the country to "Canada" and forgot to choose province
    Then, the 2nd dropdown list is changed to [Alberta, Ontario, Quebec],
    BUT the current value is still "Florida"

    Probem:
    Now I have "Canada" and "Florida" selected in the sheet

    Question:
    If the primary list is changed, can I make the 2nd drop down list to show a default value (e.g. blank or the first entry i.e. Alberta)?
    Could someone help? I have a serious problem with this issue. Example EXCEL file is attached below

    Thanks in advance
    Attached Files Attached Files
    Last edited by ginieman; 01-22-2010 at 02:53 PM.

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