+ Reply to Thread
Results 1 to 3 of 3

Auto-populate cell if data validation list has only one option

  1. #1
    Registered User
    Join Date
    01-22-2024
    Location
    Connecticut
    MS-Off Ver
    Microsoft 365
    Posts
    2

    Auto-populate cell if data validation list has only one option

    Hi all,
    I have a series of drop-down lists created via data validation which pull from a separate sheet of dynamic lists that are driven by a series of rules. In other words, my sheet consists of a series of conditional drop-down lists, each one affecting the available options in the lists that come after it.

    In order to best explain my issue I am going to describe two scenarios.
    Lets say the first drop-down list allows the user to select from a series of hardware types (cabinet knobs, drawer pulls, robe hooks, etc.). The next drop-down lists allows the user to select from a list of hardware mounting options (through-bolted, surface-mounted, or back-to-back).

    Scenario 1:
    The user selects drawer pulls from the first drop-down list. The second drop-down allows the user to select either through-bolted, surface-mounted, or back-to-back as an option.
    Scenario 1.jpg

    Scenario 2:
    The user selects cabinet knobs for the first drop-down list. In this case the second drop-down list only allows them to select through-bolted as an option since the hardware company only sells through-bolted cabinet knobs.
    Scenario 2.jpg

    Example.xlsx

    My dilemma is this: I want to retain the ability for the user to select either through-bolted, surface-mounted, or back-to-back in the first scenario, but at the same time I want this same cell to be automatically populated with "through-bolted" given the second scenario so that the user does not have to go through the action of selecting "through-bolted" from a list that has only one option anyway. There are many scenarios where a proceeding drop-down list will end up having only one option based on what was selected for preceding drop-down lists and I want to make the number of button clicks necessary for the user as low as possible.

    Any ideas or is this even possible?

    Thanks,
    Jack
    Last edited by jruddat; 03-07-2024 at 01:45 PM. Reason: Upload example workbook

  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 2406
    Posts
    44,662

    Re: Auto-populate cell if data validation list has only one option

    We cannot edit/play with pictures, please upload a SMALL sample file.
    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

  3. #3
    Registered User
    Join Date
    01-22-2024
    Location
    Connecticut
    MS-Off Ver
    Microsoft 365
    Posts
    2

    Re: Auto-populate cell if data validation list has only one option

    I just attached a file to my original post called Example.xlsx

    Thanks,
    Jack

+ 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. Auto populate dependent validation list with fist values from list
    By jwrob in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-26-2022, 07:41 PM
  2. Auto Populate Dynamic List Using Data Validation Drop Down
    By HaleServices in forum Excel General
    Replies: 1
    Last Post: 08-17-2017, 08:51 PM
  3. [SOLVED] Auto populate cell based on table option
    By JGSmith in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 08-02-2016, 11:01 AM
  4. Populate cell data based on data validation (drop down list)
    By ish_baho in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 02-05-2014, 11:47 PM
  5. Replies: 18
    Last Post: 09-18-2013, 10:29 AM
  6. How to Lock a cell based on option picked from a data validation list
    By dp0875 in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 01-31-2013, 10:53 AM
  7. Dependent Validation List - Auto Populate
    By himey77 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 02-25-2011, 11:07 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