+ Reply to Thread
Results 1 to 5 of 5

Multiple Dropdown Lists that are linked to eachother

  1. #1
    Registered User
    Join Date
    08-28-2013
    Location
    Oxford, England
    MS-Off Ver
    Excel 2010
    Posts
    12

    Multiple Dropdown Lists that are linked to eachother

    Hi,

    I am pretty new to excel so go easy on me!

    I have created a series of dropdown lists that have hundreds of options but the variables are linked. For instance; if i selected a diameter of 190mm (out of 200 different possibilities) from one of the dropdown lists, there are only 15 heights that can correspond to that diameter however the height list will still show 300 different heights.

    WHAT I WANT TO DO: when you select a height from the dropdown it only allows the corresponding diameters to be shown in the next list, not every diameter in the system.

    Thank you in advance for the help - much appreciated.

    Best Regards,

    Chris

  2. #2
    Valued Forum Contributor
    Join Date
    02-08-2012
    Location
    Newcastle, Australia
    MS-Off Ver
    Excel 2007 and Excel 2010
    Posts
    1,429

    Re: Multiple Dropdown Lists that are linked to eachother

    Hi,

    Take a look at this website...http://www.contextures.com/xlDataVal02.html

    This is how you will have to do what you are trying to achieve (possibly create your lists and named ranges on a hidden worksheet).

    Hope this helps

  3. #3
    Registered User
    Join Date
    08-28-2013
    Location
    Oxford, England
    MS-Off Ver
    Excel 2010
    Posts
    12

    Re: Multiple Dropdown Lists that are linked to eachother

    Thank you!

  4. #4
    Valued Forum Contributor
    Join Date
    02-08-2012
    Location
    Newcastle, Australia
    MS-Off Ver
    Excel 2007 and Excel 2010
    Posts
    1,429

    Re: Multiple Dropdown Lists that are linked to eachother

    No worries!

    Pease don't forget to mark this thread as solved

    Have a great day

  5. #5
    Forum Expert MickG's Avatar
    Join Date
    11-23-2007
    Location
    Banbury,Oxfordshire
    Posts
    2,650

    Re: Multiple Dropdown Lists that are linked to eachother

    This is really a reply to your recent thread, but as its closed, here it is.
    This still seems to have shortcomings because of the blanks in your data , but it may be a start.
    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. Creating forms with multiple dropdown lists
    By AnnaDana in forum Excel General
    Replies: 3
    Last Post: 06-28-2013, 02:54 PM
  2. 2 identical sheets , linked to eachother?
    By stevnb in forum Excel General
    Replies: 4
    Last Post: 12-14-2012, 07:44 AM
  3. Need code for two lists, seperate worksheets, both to update eachother automatically.
    By trickyricky in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-03-2012, 11:14 AM
  4. Summing data from multiple sheets and dropdown lists
    By Skwerl in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 11-03-2011, 08:00 PM
  5. Multiple linked dropdown Menus
    By goalieman01 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-29-2009, 01:20 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