+ Reply to Thread
Results 1 to 2 of 2

Restrict data validation list selection based on another table - dependent data validation

  1. #1
    Registered User
    Join Date
    01-14-2018
    Location
    iran
    MS-Off Ver
    2013
    Posts
    1

    Lightbulb Restrict data validation list selection based on another table - dependent data validation

    Hi All,

    I have a problem that I can't wrap my head around! and any help is MUCH appreciated...

    I want to create a data validation list that will show a different list in response to the first column of each row.
    and I want the lists to be generated according to another table.

    it's hard to explain so I have uploaded my file.

    there are two sheets, the first one is calendar where:
    for example in cell C2 I want the drop down menu to show only (all users, web users, app users) and not show "content users" because for the value in B2 which is "email marketing" we are only allowed to select these options. this is indicated in the second sheet: "list1"

    I don't know if I was able to explain what i want from this file.
    and I hope you all can help.
    thanks for your time
    Attached Files Attached Files
    Last edited by arezaeia; 01-14-2018 at 07:58 AM.

  2. #2
    Forum Moderator davesexcel's Avatar
    Join Date
    02-19-2006
    Location
    Regina
    MS-Off Ver
    MS 365
    Posts
    13,474

    Re: Restrict data validation list selection based on another table - dependent data valida

    This is probably the best place to learn how to create Create Dependent Drop Down Lists

+ 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 entry form to populate certain table dependent on validation list
    By nmorrow in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 12-10-2017, 05:22 AM
  2. Replies: 0
    Last Post: 07-01-2015, 09:49 AM
  3. Replies: 3
    Last Post: 06-04-2015, 02:27 PM
  4. displaying list based on data selection in drop down of data validation
    By paradise2sr in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 12-16-2014, 12:51 AM
  5. Pull Data from Multiple Columns Based On Data Validation List Selection
    By CHRISOK in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 05-13-2013, 11:41 PM
  6. Replies: 4
    Last Post: 02-12-2012, 11:41 AM
  7. Data Validation: Need to restrict drop-down selection
    By splenguin in forum Excel General
    Replies: 5
    Last Post: 09-08-2009, 03:46 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