Results 1 to 3 of 3

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

Threaded View

  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

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