+ Reply to Thread
Results 1 to 5 of 5

Excel Dependent drop down lists

  1. 02-13-2018, 05:27 PM #1
    JAKIV
    JAKIV is offline
    Registered User
    Join Date
    02-13-2018
    Location
    Denmark
    MS-Off Ver
    2016
    Posts
    27

    Excel Dependent drop down lists

    Hi there.

    To keep it simple..

    I got a Dropdown list with 10 names.

    I want help to..

    If I have selected "name 1" in A1, from the Dropdown list, the "name 1" should not be in the Dropdown list any more.
    In other words,,, Do not show "name 1" again when I select Dropdown list in A2
    Then there must only be 9 names left to choose from and so on.

    Kind regards
    Jan Iversen
    Reply With QuoteRegister To Reply
  2. 02-13-2018, 07:50 PM #2
    Excelko
    Excelko is offline
    Registered User
    Join Date
    06-24-2016
    Location
    Slovakia
    MS-Off Ver
    MS Office 365
    Posts
    92

    Re: Excel Dependent drop down lists

    Hi Jan,

    I tried to do what you described, I had to create some additional columns that works as dynamic list.
    You can see what I did in attached file, and as I was lazy to write all steps here I made short video where I explain it.

    https://www.youtube.com/watch?v=idOhQ98Bjz0&t=8s

    Is that what you was looking for?
    Attached Files Attached Files
    Have a fantastic day
    Reply With QuoteRegister To Reply
  3. 02-13-2018, 07:56 PM #3
    jeffreybrown
    jeffreybrown is offline
    Forum Moderator jeffreybrown's Avatar
    Join Date
    02-19-2009
    Location
    Cibolo, TX
    MS-Off Ver
    Office 365
    Posts
    10,316

    Re: Excel Dependent drop down lists

    Here is another example...

    DV0039 - Seating Plan
    HTH
    Regards, Jeff
    Reply With QuoteRegister To Reply
  4. 02-14-2018, 02:02 PM #4
    JAKIV
    JAKIV is offline
    Registered User
    Join Date
    02-13-2018
    Location
    Denmark
    MS-Off Ver
    2016
    Posts
    27

    Smile SOLVED Re: Excel Dependent drop down lists

    That's amazing :-)
    That's just what i needed
    Thanks, both of you :-)
    Kind Regards
    Jan
    Reply With QuoteRegister To Reply
  5. 02-14-2018, 06:38 PM #5
    jeffreybrown
    jeffreybrown is offline
    Forum Moderator jeffreybrown's Avatar
    Join Date
    02-19-2009
    Location
    Cibolo, TX
    MS-Off Ver
    Office 365
    Posts
    10,316

    Re: Excel Dependent drop down lists

    You are very welcome Jan. We are happy to help.

    If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Two different lists with the same name range for dependent drop-down lists
    By MMeGa in forum Excel General
    Replies: 11
    Last Post: 10-08-2021, 04:55 AM
  2. [SOLVED] Clear up to three dependent drop down lists based on selection in superior drop down list
    By theletterh in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 03-04-2016, 09:31 PM
  3. Excel Dependent Drop-down Lists or hierarchy dropdown lsit
    By richardgf in forum Excel General
    Replies: 5
    Last Post: 02-12-2015, 01:18 PM
  4. Dependent drop down lists without creating unique named lists
    By pajordan in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 09-11-2013, 12:20 PM
  5. [SOLVED] Column B drop down list with 2 options, columns C & E with dependent drop down lists
    By betic in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 09-26-2012, 03:47 PM
  6. [SOLVED] Dependent Drop Down Lists
    By Leiser in forum Excel General
    Replies: 5
    Last Post: 07-23-2012, 03:50 PM
  7. Dependent Drop Down lists (multiple drop down)
    By jijy in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 08-17-2007, 09:56 AM

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1