+ Reply to Thread
Results 1 to 4 of 4

Dynamic Data Validation

  1. #1
    Forum Contributor
    Join Date
    02-09-2007
    Location
    UK
    MS-Off Ver
    2016
    Posts
    230

    Dynamic Data Validation

    Hi All,

    I would like to create a dynamic Data Validation list in 'Service Costs' Sheet in cells B2 C2 & D2 - All to have a 'Parent child' relationship - So when for example 106 is selected in B2 the only engine options that come up in C2 are;

    1.5 D
    1.1 Petrol
    1.4 Petrol
    1.6 Petrol
    1.5 D
    1.1 Petrol
    1.4 Petrol
    1.6 Petrol

    and depending on which one of these you select in C2 it will determined what will appear in D2 options.

    Sorry to ask but I have read 20+ topics on this now and watched countless youtube videos but cant get it to work!!
    Attached Files Attached Files

  2. #2
    Forum Moderator Paul's Avatar
    Join Date
    02-05-2007
    Location
    Wisconsin
    MS-Off Ver
    2016/365
    Posts
    6,799

    Re: Dynamic Data Validation

    Did you happen to review this page, which outlines the process step by step? Pay particular attention to the "Using Dynamic Lists" at the bottom.

    http://www.contextures.com/xldataval02.html

  3. #3
    Forum Contributor
    Join Date
    02-09-2007
    Location
    UK
    MS-Off Ver
    2016
    Posts
    230

    Re: Dynamic Data Validation

    Thanks for the prompt reply, yes I found that one and watched the video but cant get any of it to work for me in this application.

  4. #4
    Forum Guru MarvinP's Avatar
    Join Date
    07-23-2010
    Location
    Woodinville, WA
    MS-Off Ver
    Office 365
    Posts
    15,266

    Re: Dynamic Data Validation

    Hi,

    Search on the terms "Excel Cascading" for more information or http://excel-user.blogspot.com/2011/...ion-lists.html
    One test is worth a thousand opinions.
    Click the * Add Reputation below to say thanks.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

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