+ Reply to Thread
Results 1 to 2 of 2

Please help! multiple drop downs dependent on first

  1. #1
    Registered User
    Join Date
    08-23-2018
    Location
    Union City, CA USA
    MS-Off Ver
    office365
    Posts
    54

    Please help! multiple drop downs dependent on first

    hi guys,

    new to these boards.

    i have a second drop down which is dependent on the first drop down but for the life of me, can't figure out how to get a third drop down to be dependent also on the first. in the attached screen shot, folks will select on the main sheet a "dept" which is referenced to column K.

    after selecting "CRS" (as an example), the next drop they can select is from column O "CRS LIST". I have this part WORKING.

    This is the part I need help on.

    The third drop down they can select from should reference column R "CRS-JOBS" but I cant get it to show up. Can someone please help? I am desperate!

    Thank you

    list.JPG

  2. #2
    Forum Expert dflak's Avatar
    Join Date
    11-24-2015
    Location
    North Carolina
    MS-Off Ver
    365
    Posts
    7,920

    Re: Please help! multiple drop downs dependent on first

    https://www.ablebits.com/office-addi...n-lists-excel/

    and if that doesn't work, try this: http://www.utteraccess.com/wiki/Casc...ists_%28VBA%29.
    One spreadsheet to rule them all. One spreadsheet to find them. One spreadsheet to bring them all and at corporate, bind them.

    A picture is worth a thousand words, but a sample spreadsheet is more likely to be worked on.

+ 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. Initial default drop downs and dependent default drop downs
    By hudsone777 in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 12-07-2016, 07:05 PM
  2. Dependent Drop Downs
    By Bumblbree in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 01-29-2016, 11:45 AM
  3. [SOLVED] Dependent drop downs
    By gameplayer in forum Excel General
    Replies: 2
    Last Post: 12-04-2015, 11:49 AM
  4. Clearing multiple dependent drop downs.
    By CustardSquare in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 09-22-2014, 09:49 PM
  5. Create drop downs with multiple dependent cells
    By usurrao in forum Excel General
    Replies: 2
    Last Post: 09-22-2014, 05:45 AM
  6. multiple dynamic dependent drop downs
    By atomicrabbit in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 01-29-2014, 10:54 PM
  7. Dependent Drop-Downs
    By braydon16 in forum Excel General
    Replies: 2
    Last Post: 12-08-2011, 05:06 PM

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