+ Reply to Thread
Results 1 to 5 of 5

Looking how to do multiple dependaent drop downs

  1. #1
    Registered User
    Join Date
    11-20-2020
    Location
    USA
    MS-Off Ver
    2010,2016 and 2019
    Posts
    5

    Looking how to do multiple dependaent drop downs

    Good afternoon. I am looking to do a spread sheet for our condo that assists in enter information and eliminate potential wrong addresses. Our condo has 7 villas. Each Villa has multiple buildings. Each building has a different number of units. I am looking that when I enter a Villa number, the next box's drop down has only the building numbers for that villa. After the building is selected, the next drop down box will have only the list of letters for that building. example Villa 22 is selected, Villa 22 has 8 buildings, building 2 has 6 units. so I would select Villa 22, the drop down in next box would be 1,2,3,4,5,6,7,8. I select 2, the next drop down would be A,B,C,D.E,F. How can I set this up? I am a novice so be gentle. lol Thank you all for you help.

  2. #2
    Forum Contributor
    Join Date
    04-24-2020
    Location
    Woodbridge, VA
    MS-Off Ver
    2016
    Posts
    275

    Re: Looking how to do multiple dependaent drop downs

    Without a file to look at, give this a try. Or just Google multi dependent drop down list in excel

    https://www.youtube.com/watch?v=NhtsVTeGywc

  3. #3
    Registered User
    Join Date
    11-20-2020
    Location
    USA
    MS-Off Ver
    2010,2016 and 2019
    Posts
    5

    Re: Looking how to do multiple dependaent drop downs

    Thank you but this doesn't work because I am only using numbers for certain field and it won't let me name the range by just number.

  4. #4
    Forum Expert
    Join Date
    12-27-2012
    Location
    market harborough, england
    MS-Off Ver
    Excel 2010
    Posts
    1,843

    Re: Looking how to do multiple dependaent drop downs

    User Form approach as per attached file.
    To make numbers work enter them with a preceding "'" (single apostrophe) - Excel treats this as a text entry.
    It does NOT work if you try to format the column as text.
    Or try this method of entry with the site recommended by other post.
    torachan.
    Attached Files Attached Files

  5. #5
    Registered User
    Join Date
    11-20-2020
    Location
    USA
    MS-Off Ver
    2010,2016 and 2019
    Posts
    5

    Re: Looking how to do multiple dependaent drop downs

    Thank you, but this is a little beyond what I know at this time.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Multiple Drop-Downs and Different Images
    By kellier180 in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 05-27-2020, 08:31 AM
  2. [SOLVED] Creating multiple drop-downs based on primary drop-down selected
    By dcwan in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 03-30-2020, 06:13 PM
  3. Please help! multiple drop downs dependent on first
    By D8THSTAR in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 08-23-2018, 02:49 PM
  4. Multiple Drop Downs
    By wil79 in forum Excel General
    Replies: 3
    Last Post: 12-11-2017, 10:47 AM
  5. [SOLVED] Multiple drop downs
    By Treecko in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 12-30-2013, 07:24 PM
  6. Multiple drop dependant drop downs in single cell
    By LittleJerry in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 09-07-2012, 02:21 PM
  7. Cell Dependaent on Drop Down Help
    By Inxane in forum Excel General
    Replies: 4
    Last Post: 04-14-2008, 12:27 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1