Results 1 to 11 of 11

Cascading Validation Lists

Threaded View

  1. #1
    Forum Contributor
    Join Date
    05-24-2012
    Location
    Cork, Ireland
    MS-Off Ver
    Excel 365
    Posts
    149

    Cascading Validation Lists

    Hi,

    I've attached a sample file which outlines roughly what I'm working with.

    I will have users filling out cells (e.g. on Input sheet) and want to cascade the drop-down lists based on selections made. The basis for these selections is on the LISTS sheet.

    So for Area, if they choose AREA1, then the Main Activity should only have 1,2,3,4,5 as available drop-down options and if they choose 1, then Secondary Task should only have A or B as options in that drop-down and finally Supervisor option should only be XX.

    My question is, is there any quick way to create these cascading drop-down lists from the structure I have currently in place on the LISTS sheet. Or am I going to have to rearrange the data on a separate sheet? I will have up to 40 'AREAS' with dependent selections.

    Any help greatly appreciated!
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 2
    Last Post: 06-19-2014, 10:39 PM
  2. question about cascading drop down lists
    By teacher_rob in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 04-13-2013, 01:39 PM
  3. Cascading down down lists
    By troygeri in forum Excel General
    Replies: 4
    Last Post: 06-07-2011, 10:46 PM
  4. Excel 2007 : Cascading Validation lists
    By ellsworth2000 in forum Excel General
    Replies: 7
    Last Post: 05-03-2011, 07:00 PM
  5. Cascading Dynamic Dropdown Lists
    By choop in forum Excel General
    Replies: 4
    Last Post: 06-14-2006, 12:30 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