+ Reply to Thread
Results 1 to 3 of 3

dependent data validation drop down list

  1. #1
    Registered User
    Join Date
    11-20-2014
    Location
    Madison, WI
    MS-Off Ver
    Excel for MAC 2011
    Posts
    50

    dependent data validation drop down list

    I have a data entry cell in a sheet asking for the users location (state). If the state entered is Wisconsin (WI), I want the next data entry cell to be a drop down menu with all of Wisconsin's counties listed. If the state selected is NOT Wisconsin, I want that data entry cell to accept any entry...and NOT be a drop down menu. Is this possible? If so, how can I make this happen?

    I have already set up the state drop down list and formatted those cells as a named table. Same with the WI Counties. I just don't know if or how I can get the County data entry cell to become a drop down menu if WI is selected and have no data validation rules if any other state is selected.

    Thanks!
    Attached Files Attached Files
    Last edited by UWBadger; 10-22-2021 at 02:28 PM.

  2. #2
    Forum Expert
    Join Date
    05-05-2015
    Location
    UK
    MS-Off Ver
    Microsoft Excel for Microsoft 365 MSO (Version 2402 Build 16.0.17328.20068) 64-bit
    Posts
    28,197

    Re: dependent data validation drop down list

    Please see yellow banner on how to post a sample workbook.
    If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.

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

    Re: dependent data validation drop down list

    adjacent to each county you will have to have the state in the left hand column.
    give us a workbook laid out like that and it is relatively simple to have dependent dropdowns
    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. [SOLVED] Data Validation Dependent Drop Down List - Source Formula too Long
    By Pereshez in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 07-04-2021, 06:28 PM
  2. [SOLVED] Index/match, data validation, dependent drop down, unique list
    By _JJ_ in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 11-09-2020, 02:01 AM
  3. Dependent Data Validation Drop Down List for multiple rows?
    By Howie Dean in forum Excel Formulas & Functions
    Replies: 10
    Last Post: 03-16-2018, 05:31 PM
  4. Replies: 0
    Last Post: 04-24-2015, 02:27 PM
  5. [SOLVED] Data Validation - Drop-down Dependent List
    By l3il3i in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-21-2014, 03:46 AM
  6. Dependent Data Validation/Drop Down
    By mpn1925 in forum Excel General
    Replies: 1
    Last Post: 08-10-2011, 01:19 PM
  7. Replies: 2
    Last Post: 05-12-2011, 09:23 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