 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / New Users / November 2006Validation List
Got a problem with a Validation List issue, and i figured this Group should be able to come up with a simple solution. I got this Spreadsheet that i will use to "parse/code/de-code" information in. And I got some Values that I have in a differend Worksheet. Problem: I have 13 differnt "Class" categories, and each of them got 3-20 Sub-Classes. However if i choose Class 1, I like to ONLY get the Sub-Classes for Class 1 in a Validation List. Tried with IF("InputCell" = "Class1Name","Class1Sub-ClassRange", "") it work..but only to Class 7... You can create dependent data validation lists. There are instructions here: http://www.contextures.com/xlDataVal02.html > Got a problem with a Validation List issue, and i figured this Group > should be able to come up with a simple solution. [quoted text clipped - 10 lines] > Tried with IF("InputCell" = "Class1Name","Class1Sub-ClassRange", "") it > work..but only to Class 7...  SignatureDebra Dalgleish Contextures http://www.contextures.com/tiptech.html Thanks for that helpfull tip Debra, however it do not help me in this case. My "Validation List" do not have only "one word values", in fact most of them have multiple up to 70carracters. And I have about 15 Main and 150 sub-Catagories that i need to sort. And as you might understand I dont want all 150 sub-Cat. to show up on all 15 main Cat. Got any other suggestions? The link that I posted included instructions for dependent lists with multiple word items: http://www.contextures.com/xlDataVal02.html#TwoWord > Thanks for that helpfull tip Debra, however it do not help me in this > case. [quoted text clipped - 5 lines] > > Got any other suggestions? SignatureDebra Dalgleish Contextures http://www.contextures.com/tiptech.html Sorry I guess i dident read everything. Thanks again. |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.