+ Reply to Thread
Results 1 to 6 of 6

Need help making multiple lists that are dependent on the first list.

  1. #1
    Registered User
    Join Date
    01-23-2019
    Location
    NJ,NJ
    MS-Off Ver
    Windows 10
    Posts
    3

    Need help making multiple lists that are dependent on the first list.

    I need help making a few drop down lists that are all dependant on the selection from the first drop down list. Basically, I want the first list to have a few options and if you pick one option 3 more lists will appear that are all based on the first selection.

    Example:

    Main List:
    Drywall
    Studs
    Plywood
    Joint Treatment

    If someone chooses drywall 3 new lists will populate:
    List 1:
    1/4"
    1/2"
    5/8"
    Enter value

    List 2:
    4x8
    4x10
    4x12
    Enter value

    List3:
    Type X
    Type C
    Non Rated
    Enter Value

    If someone chooses studs 3 different lists will need to appear. How can I do this?

  2. #2
    Valued Forum Contributor
    Join Date
    01-16-2012
    Location
    England
    MS-Off Ver
    MS 365
    Posts
    1,397

    Re: Need help making multiple lists that are dependent on the first list.

    bender,

    Attached does what you want.
    Main List in Col A populates DropList in B10.
    Name the Ranges in Cols B - D as "Drywall(whatever is in B1 or C1 or D1)", and in Cols F - H as "Stud(Whatever)", etc.
    Data Validation Formula in B12, B14 and B16 is then B10&"SCREWS" or whatever Headers you use.
    If B4 is 'Dry Wall', the Dependent Droplists will be filled by Cols B - D.
    If B4 is 'Studs', they will be filled by Cols F - H.

    Hope this helps

    Ochimus
    Attached Files Attached Files
    Last edited by Ochimus; 01-23-2019 at 06:42 PM.

  3. #3
    Registered User
    Join Date
    01-23-2019
    Location
    NJ,NJ
    MS-Off Ver
    Windows 10
    Posts
    3

    Re: Need help making multiple lists that are dependent on the first list.

    Thanks for sending that over Ochimus. I tried to mimic what you did but wasn't able to get the list to work. I believe I did it step by step correctly but my the second option in the main drop down list called Underlayment isn't populating the next drop down menus correctly. The first option called drywall is working fine though.
    Attached Files Attached Files

  4. #4
    Forum Guru Bo_Ry's Avatar
    Join Date
    09-10-2018
    Location
    Thailand
    MS-Off Ver
    MS 365
    Posts
    7,211

    Re: Need help making multiple lists that are dependent on the first list.

    You have extra space at List B2 "Underlayment " , remove the space.

  5. #5
    Registered User
    Join Date
    01-23-2019
    Location
    NJ,NJ
    MS-Off Ver
    Windows 10
    Posts
    3

    Re: Need help making multiple lists that are dependent on the first list.

    Hey Bo thanks for answering. I'm having trouble finding this space. Can you help me?

  6. #6
    Forum Guru Bo_Ry's Avatar
    Join Date
    09-10-2018
    Location
    Thailand
    MS-Off Ver
    MS 365
    Posts
    7,211

    Re: Need help making multiple lists that are dependent on the first list.

    Sorry, Not at B2, At A3

    Untitled.png

+ 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. List Dependent on Other Lists
    By jadown in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 08-09-2017, 11:20 AM
  2. Making a dependent drop down list
    By viber52 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 06-25-2015, 05:11 PM
  3. Replies: 4
    Last Post: 12-12-2013, 07:30 PM
  4. Creating dependent lists on the first list
    By jvermillion in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 12-09-2013, 08:21 AM
  5. Validation Lists - Multiple dependent lists with unique values
    By Lewigi in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-16-2013, 06:42 AM
  6. List Dependent Lists
    By orly_sm in forum Excel General
    Replies: 2
    Last Post: 02-06-2013, 10:19 AM
  7. Replies: 6
    Last Post: 03-27-2012, 12:39 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