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.
Last edited by anto1510; 11-13-2010 at 02:12 AM.
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.
Thank you so much
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks