+ Reply to Thread
Results 1 to 2 of 2

Conditionally autofill the value of drop down lists

  1. #1
    Registered User
    Join Date
    12-12-2018
    Location
    Nashville
    MS-Off Ver
    2016
    Posts
    5

    Conditionally autofill the value of drop down lists

    I'm creating a template that will provide me with multiple billing rates for attorneys.

    There are three criteria which will determine the values of the billing rates, (Title, Track, Class Year).

    I have used drop down boxes to provide me with all of the relevant options for each of these field

    Title = Partner or Associate or Other
    Track = On Track or Off Track
    Class Year = all years between 2020-2010

    When the value "Associate" is selected in the first drop down (Title), then the second (Track) and third (Class Year) drop downs need to be completed.
    What I would like to do accomplish is when "Associate" is NOT selected in the fist drop down box (Title), then the second and third drop down boxes would auto-populate to "n/a". But is "Associate" if selected then the second and third drop down need to display the options in the list above.

    Thoughts?
    Attached Files Attached Files
    Last edited by cjohnson092; 12-10-2020 at 12:14 PM.

  2. #2
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... occasionally based in Ireland.
    MS-Off Ver
    O365 (PC) V 2403
    Posts
    43,900

    Re: Conditionally autofill the value of drop down lists

    Hi there.

    A picture is worth 1,000 words. An Excel sheet is worth 1,000 pictures.

    Please read the yellow banner about sample worksheets, at the top of the screen. Act on its guidelines and post a SMALL sample sheet.
    Glenn




    None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU.

    Temporary addition of accented to illustrate ongoing problem to the TT: L? fh?ile P?draig sona dhaoibh

+ 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. Dependent Drop Down Lists Autofill
    By mlbthomas in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-29-2019, 11:44 PM
  2. Replies: 1
    Last Post: 10-30-2018, 01:31 AM
  3. [SOLVED] Autofill a cell based on results of multiple dynamic drop down lists
    By jmp764 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 08-26-2014, 05:51 AM
  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. 3 dependant drop down lists & one autofill based on those selections
    By claire_wilson in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 03-17-2013, 06:59 PM
  6. Conditionally hide drop down lists
    By 31RHCP in forum Excel General
    Replies: 0
    Last Post: 07-13-2010, 08:26 PM
  7. drop down lists referencing tables creating other drop down lists!!
    By Stumped- in forum Excel - New Users/Basics
    Replies: 3
    Last Post: 08-07-2009, 11:29 AM

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