+ Reply to Thread
Results 1 to 4 of 4

Creating dependent data validation lists in multiple rows

  1. #1
    Registered User
    Join Date
    08-03-2011
    Location
    Kampala, Uganda
    MS-Off Ver
    Excel 2007
    Posts
    41

    Creating dependent data validation lists in multiple rows

    Hi all,

    How can i generate a data entry screen with dependent data validation (i.e. column wise) for multiple rows.

    For example, in the sheet I have attached: Suppose an entry done in column C is "Bukoto", I want the drop down menu in column D to only show the possible centre numbers (i.e. 001 and 005 only). and when a given centre number is shown in column D, I want it to show the possible group numbers (i.e. 01, 02, 03, ..., 08 only); and when a group number is selected in column E, I want the dropdown menu in column F to show names of only those members that are in the selected area name, centre number, and group number.

    See attachment for details. - The first column is where data entry will be done. And the second sheet shows the details of members from different areas, centre numbers and group numbers.

    All help will be greatly appreciated.

    Thanks,
    R.

  2. #2
    Forum Expert dflak's Avatar
    Join Date
    11-24-2015
    Location
    North Carolina
    MS-Off Ver
    365
    Posts
    7,908

    Re: Creating dependent data validation lists in multiple rows

    This article shows one method of doing this using VBA and pivot tables. http://www.utteraccess.com/wiki/inde...ists_%28VBA%29.
    One spreadsheet to rule them all. One spreadsheet to find them. One spreadsheet to bring them all and at corporate, bind them.

    A picture is worth a thousand words, but a sample spreadsheet is more likely to be worked on.

  3. #3
    Registered User
    Join Date
    08-03-2011
    Location
    Kampala, Uganda
    MS-Off Ver
    Excel 2007
    Posts
    41

    Re: Creating dependent data validation lists in multiple rows

    Thanks deflak.

    I am not so familiar with VBA coding. I mainly use excel functions to get around some of these things. If you could assist with an alternative using the inbuilt excel functions, I'd appreciate that too.

    Thanks again,
    R.

  4. #4
    Forum Expert dflak's Avatar
    Join Date
    11-24-2015
    Location
    North Carolina
    MS-Off Ver
    365
    Posts
    7,908

    Re: Creating dependent data validation lists in multiple rows

    This took some figuring out and it's complex, so I wrote up the logic in a word document. The drop down lists are in Column AA. It took a lot of helper columns to make this work, but it can me reproduced lock step for any number of cascades.

+ 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. Replies: 0
    Last Post: 07-01-2015, 09:49 AM
  2. Replies: 3
    Last Post: 10-08-2013, 11:48 AM
  3. Replies: 2
    Last Post: 09-07-2013, 03:55 AM
  4. Validation Lists - Multiple dependent lists with unique values
    By Lewigi in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-16-2013, 06:42 AM
  5. Multiple dependent Data validation lists
    By edphill in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 02-01-2013, 08:01 AM
  6. [SOLVED] Data Validation using multiple dependent drop down lists
    By ceruppel in forum Excel General
    Replies: 4
    Last Post: 12-17-2012, 06:39 PM
  7. Validation To Create Multiple Dependent Lists
    By Borske in forum Excel General
    Replies: 4
    Last Post: 10-23-2009, 11:37 AM

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