+ Reply to Thread
Results 1 to 2 of 2

Variable Drop Down Lists

  1. #1
    Registered User
    Join Date
    11-15-2011
    Location
    Liverpool, England
    MS-Off Ver
    Excel 2003
    Posts
    1

    Variable Drop Down Lists

    Hi

    1st post but i've found invaluable help in the past from this site, but really stuck on something now.

    I've created a variable drop down list for 4 different categories all linked, but I can only get it to link on the first line - the plan could have any number of actions which need to go in these categories (i've put 50 down as an example).

    Is there a quick way or will I have to do different data validation for each line of the action plan?

    Cheers
    Attached Files Attached Files

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

    Re: Variable Drop Down Lists

    Hi williduck and welcome to the forum,

    I believe you are looking for the topic Cascading Dropdowns. See if any of these links help:
    http://www.officearticles.com/excel/...soft_excel.htm
    http://www.bluepecan.co.uk/excel_tra...alidation.html
    http://www.tushar-mehta.com/excel/ne...wns/index.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