Results 1 to 2 of 2

Dependant Data Validation to Supply final answer

Threaded View

  1. #1
    Registered User
    Join Date
    03-22-2015
    Location
    Edmonton, Canada
    MS-Off Ver
    2010
    Posts
    1

    Dependant Data Validation to Supply final answer

    Hello,

    I am making a sheet as such:

    See Picture Capture.PNG

    On another sheet (Sheet 2, Column A), I want to be able to select the data from Sheet1 Column A (any number from 1-6), however I would like it so that If I choose 2 in Column A, than Column B only gives me the option to select "Blue" or "Green". I would like this to continue through column C following the same rules, and give me an answer in Column D.

    So for Example on Sheet2 Column A I have the options from 1-6. If I select 6 than Column B gives me the options "blue" or "red". If I select "Blue" than Column C gives me the options "Circle" or "Square". If I select Circle than Column D equals Thirteen.

    Can anyone help me figure out how to do this?



    Thanks!
    Last edited by SKallday; 03-22-2015 at 06:56 PM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Dependant data validation with dependant default value
    By JamesMeek in forum Excel General
    Replies: 2
    Last Post: 04-08-2013, 10:16 AM
  2. Supply a column of table as a Data Validation list
    By Chandrajit in forum Excel General
    Replies: 7
    Last Post: 03-11-2012, 05:01 AM
  3. Plus and Minus signs to show up in final answer
    By Rayaus65 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 06-21-2010, 05:32 AM
  4. Dependant? Data Validation
    By matrixskydiver in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 12-08-2007, 07:56 PM
  5. final answer to run macro at certain time
    By as_sass in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 10-18-2005, 01:05 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