Data-Validation

[anto1510]

Hi All,
I need an help.
Using option Validation or any other formulas i need to complete this assignment.

If suppose an user select any the cell in Column A then it should provide a drop down menu giving an option to user to select an item from the menu and in the Column B it should display again the list of submenu options depending on the option selected in Column A.
For example
In Column A options should be Solid and Liquid.If the user select solid then in Column B it should give options like Rock and Wood.If the user select option liquid then it should give options like water and cool drink.

[Claymation]

Have you tried anything out yet that isn't working that you can share to see if we can help you? If not, give this a read and then post back if you have additional questions.

http://www.contextures.com/xldataval02.html

Hope that helps.

[anto1510]

Thank you so much