Hello all,

Having never used Microsoft Excel, I am trying to create a tool that will allow me to use sucessive, dependent drop down boxes that will allow me to extract a specfic value from large lists, and ultimately allowing the user to calculate a total from these values. The options available in each subsequent drop down menu should be restricted to the item chosen in the prior drop down. I have been doing some research on Google and watching Youtube videos and am convinced that I can do this through the use of the Data Validation tool. However, it seems that the use of Data Validation is limited to a single tier. Is it possible to do this?


Thanks,
Khoa Nguyen