Results 1 to 2 of 2
  1. #1
    Star Lounger
    Join Date
    Jun 2002
    Location
    Johannesburg, Gauteng, South Africa
    Posts
    59
    Thanks
    2
    Thanked 0 Times in 0 Posts

    Values of drop down list dependent on values of another list

    Hi all, been a while since I've needed to use the forum's collective expertise, but I trust you are all well.
    What I want is, in Sheet2, to have 3 drop down lists: "Province", "Town" and "Suburb"

    "Province" must allow selection from Unique Values in Range A2:A13902 in Sheet1
    Depending on what value is selected in "Province", "Town" must allow selection from values in range B2:B13902 in Sheet1
    Depending on what value is selected in "Town", "Suburb" must allow selection from values in range C2:C13902 in Sheet1

    I have searched the forum but am unable to come up with what I need.

    Thanks
    Raymond
    Attached Files Attached Files

  2. #2
    3 Star Lounger Supershoe's Avatar
    Join Date
    Apr 2014
    Location
    Austin, TX
    Posts
    252
    Thanks
    1
    Thanked 36 Times in 34 Posts
    Look here under D for data validation
    http://www.contextures.com/tiptech.html

Posting Permissions

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