Results 1 to 6 of 6

Thread: Drop down lists

  1. #1
    Seeker RidinFearless's Avatar
    Join Date
    Dec 2019
    Posts
    7
    Articles
    0
    Excel Version
    Office2016

    Drop down lists



    Register for a FREE account, and/
    or Log in to avoid these ads!

    I want to create a drop don list with many choices.
    After the first choice is made, the next drop list will have all the same choices except the one that was selected in the first drop down list.
    And so on until all choices are exhausted.

  2. #2
    Magician NoS's Avatar
    Join Date
    Jan 2013
    Location
    British Columbia
    Posts
    831
    Articles
    0
    Excel Version
    Excel 2010
    Google "Dependent Drop Down Lists"

  3. #3
    Seeker RidinFearless's Avatar
    Join Date
    Dec 2019
    Posts
    7
    Articles
    0
    Excel Version
    Office2016
    Thanks. I am a novice and didn’t know the term. I will do some research.

  4. #4
    Seeker RidinFearless's Avatar
    Join Date
    Dec 2019
    Posts
    7
    Articles
    0
    Excel Version
    Office2016
    From what have read, a “Dependant Drop Down” is not what I need.

  5. #5
    Magician NoS's Avatar
    Join Date
    Jan 2013
    Location
    British Columbia
    Posts
    831
    Articles
    0
    Excel Version
    Excel 2010
    Perhaps it's Dynamic Data Validation you're looking for.

  6. #6
    Seeker RidinFearless's Avatar
    Join Date
    Dec 2019
    Posts
    7
    Articles
    0
    Excel Version
    Office2016
    NoS. Yes I think that is it. If it helps anyone else I also seen the term “shrinking drop down list” and “hiding selections already used”

Posting Permissions

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