+ Reply to Thread
Results 1 to 2 of 2

Create a Dependent Drop-Down List

  1. #1
    Registered User
    Join Date
    12-19-2019
    Location
    Queens, NY
    MS-Off Ver
    2013
    Posts
    28

    Create a Dependent Drop-Down List

    Hello, I'm trying to create a production schedule sheet for work and I'm having trouble creating a dependent drop-down list. I'm familiar with creating typical/simple drop-down lists, but I need help with some of the more advanced tasks (advanced for me anyway!). I've attached a sample sheet to illustrate what I'm looking to accomplish.

    I have a list of customers and jobs on one tab (illustrated on my sheet as car makes & models). My production schedule is on a separate tab. The schedule will be a table of anywhere from 50-500 rows. I'd like to have my customers (MAKES) appear as a drop-down list (which I am able to accomplish), while the jobs (MODELS) column is a drop-down list of jobs that is dependent on which customer is picked. For example, if I choose 'Chevrolet' from the MAKE column in my production list, I'd like the list in the MODEL column to be a drop-down list of only 'Tahoe', 'Malibu' or 'Equinox'. In the next row, if I choose 'Honda' as the MAKE, I'd like the list in the MODEL column to be a drop-down list of only 'Accord' or 'Pilot'.

    I've tried using 'indirect' functions and 'filter' functions within the Data Validation settings but I haven't had any luck. Any help would be greatly appreciated.

    I apologize if this is already shown on a pre-existing thread. I tried to look for my specific answer, but was unable to find it.

    Thank you!
    James
    Attached Files Attached Files

  2. #2
    Forum Expert torachan's Avatar
    Join Date
    12-27-2012
    Location
    market harborough, england
    MS-Off Ver
    Excel 2010
    Posts
    4,360

    Re: Create a Dependent Drop-Down List

    method using a macro in the sheet module - place quantity in 'F2' - hit enter and dependent comboboxes appear across the row.
    to extend the table simply put a quantity in 'F3' and repeat - the 'structured table' is dynamic and the above process only takes place within the confines of the table.
    Attached Files Attached Files
    Torachan,

    Mission statement; Promote the use of Tables, Outlaw the use of 'merged cells' and 'RowSource'.

+ 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. Replies: 3
    Last Post: 01-24-2024, 10:00 AM
  2. Create a Dynamic Dependent drop-down list with unique value
    By pvshah80 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 03-14-2020, 02:47 AM
  3. [SOLVED] How To Create a Cells Dependent on a Drop Down List Selection
    By DrCornikov in forum Excel Formulas & Functions
    Replies: 12
    Last Post: 08-04-2017, 03:47 AM
  4. Create a dependent drop down list
    By nancyching1711 in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 04-29-2015, 12:44 AM
  5. Create Dependent Drop Down List
    By ININ1994 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 06-12-2014, 02:35 PM
  6. Create a dependent drop down list with dynamic list
    By JSmith1504 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 04-01-2014, 09:15 AM
  7. Create Default for Dependent Drop Down List
    By moskealy in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 05-14-2010, 03:11 PM

Tags for this Thread

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