Can some kind soul help me?
Here is my requirement. The thrid list is dependent on choices of the first and second list.
Class A --- choose Maths ------choose Further Maths or General Maths
Class A ---- choose English ----- Choose Writing or Spelling or Converstaion
Class B --- Choose Science --- choose Biology
Class B ----Choose German Lang ---- choose German converstation or German writing
Class C --- Choose Tuba -----Choose Reading of music notes
Class C --- Choose Flute -----same choice above i.e. Reading of music notes
I am able to use validation list for the first drop down list for Class i.e.Define name: Class and the second drop down list for Subjects i,e, =INDIRECT( )
Can please help me with the third drop down menu?
I have used the entire afternoon looking over the posts and the closest I have is http://www.contextures.com/xlDataVal02.html
However, I am still unclear about how to make my thrid list adn where to place the thrid list.
By the way, I am using Excel 2007.
Please use simple language. I am very new to all the intricacies of excel and have been driven by work requirments to learn baout pivot tables and validation within 2 days.
Thanks in advance.
Here is my requirement. The thrid list is dependent on choices of the first and second list.
Class A --- choose Maths ------choose Further Maths or General Maths
Class A ---- choose English ----- Choose Writing or Spelling or Converstaion
Class B --- Choose Science --- choose Biology
Class B ----Choose German Lang ---- choose German converstation or German writing
Class C --- Choose Tuba -----Choose Reading of music notes
Class C --- Choose Flute -----same choice above i.e. Reading of music notes
I am able to use validation list for the first drop down list for Class i.e.Define name: Class and the second drop down list for Subjects i,e, =INDIRECT( )
Can please help me with the third drop down menu?
I have used the entire afternoon looking over the posts and the closest I have is http://www.contextures.com/xlDataVal02.html
However, I am still unclear about how to make my thrid list adn where to place the thrid list.
By the way, I am using Excel 2007.
Please use simple language. I am very new to all the intricacies of excel and have been driven by work requirments to learn baout pivot tables and validation within 2 days.
Thanks in advance.