+ Reply to Thread
Results 1 to 6 of 6

dependent validation and multiple choice lists

  1. #1
    Registered User
    Join Date
    01-22-2014
    Location
    Pretoria, South Africa
    MS-Off Ver
    Excel 2010
    Posts
    58

    dependent validation and multiple choice lists

    Dear Forum members,

    I urgently need assistance with building a excel record inventory template that uses dependent drop downs and multiple choice lists on the same template worksheet.

    I can be considered a novice Excel user when it comes to this functionality.

    I am attaching the Excel workbook with description on each sheet of what is expected, as trying to describe my need here would be a lot of complicated text.

    I would greatly appreciate your help and guidance on this.

    Attachment 325452Attachment 325452

    Louisa Venter
    Attached Files Attached Files

  2. #2
    Registered User
    Join Date
    05-08-2012
    Location
    Sri Lanka
    MS-Off Ver
    2010
    Posts
    9

    Re: dependent validation and multiple choice lists

    Hi,

    See below. This definitely help you

    Dynamic Drop Down List
    Keashan

  3. #3
    Registered User
    Join Date
    01-22-2014
    Location
    Pretoria, South Africa
    MS-Off Ver
    Excel 2010
    Posts
    58

    Re: dependent validation and multiple choice lists

    Dear Keashan, thank you for your recommendation. However, my request is a little more involved than just creating drop down lists in a one on one relationship. I would appreciate any additional assistance which you could provide though.

    Louisa

  4. #4
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 2000/3/7/10/13/16
    Posts
    51,261

    Re: dependent validation and multiple choice lists

    Hi welkom aan die voorum SA ex-pat here from PE and Klerksdorp. How goes it in P-town?

    I think the attached will give you a good idea on how to do what you want. The basis is that for every different or sub drop-down, it needs to have its own range and range name. The range are best named with what the "previous" drop-down result will show. The sub-drop-downs use INDIRECT() as their "refers to"

    I have created 1 2-tier dependant drop-down, but the principal is the same for the next set/s. The more you have though, the more complex it becomes
    Attached Files Attached Files
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford

  5. #5
    Registered User
    Join Date
    01-22-2014
    Location
    Pretoria, South Africa
    MS-Off Ver
    Excel 2010
    Posts
    58

    Re: dependent validation and multiple choice lists

    Hallo Ford,

    All is well in the land of e-tolls and potholes. We are no longer in the land of milk an honey, as we are in recession and [apparently] depression

    Thank you for the assistance. Creating the dynamic drop downs is the easy part. I am more concerned about dealing with the following:

    a) in a single list, I have one word and multiple word items, e.g. Finance, Human Resources, Regulatory Risk Reporting. When creating the drop downs, it works perfectly with the single word items, but not with the multiple word items. Where multiple word items should have a dependent drop down in the next cell, the drop downs are non-responsive. Clicking on the drop down arrows does nothing.

    b) Some of the columns should allow for multiple choice lists. For example an item can belong to more than one Business Unit in a Franchise. The client does not want the same item captured on multiple rows to indicate that they belong to more than one BU. The BU cell should contain the names of all the BU's the item belongs too. How do I go about creating multiple choice list that exist in a relationship to a series of dependent validation lists?

    Regards,

    Louisa

  6. #6
    Registered User
    Join Date
    01-22-2014
    Location
    Pretoria, South Africa
    MS-Off Ver
    Excel 2010
    Posts
    58

    Re: dependent validation and multiple choice lists

    Dear Forum Members,

    I successfully added a third dependent drop down.

    I then tried the fourth dependent drop down, but it does not work. I assume it has something to do with naming the range properly so that it links to the specific choice in the third drop down? I tried different variations of AA1, but did not manage to get it working properly. What am I missing?

    I would appreciate your assistance.



    Regards,

    Louisa
    Attached Files Attached Files

+ 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. 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
  2. Multiple dependent Data validation lists
    By edphill in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 02-01-2013, 08:01 AM
  3. [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
  4. Validation lists dependent on first list choice
    By SkeptiCol in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 07-11-2010, 11:12 PM
  5. Validation To Create Multiple Dependent Lists
    By Borske in forum Excel General
    Replies: 4
    Last Post: 10-23-2009, 11:37 AM

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