| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Can I set up sublists under Data Validation
My list is getting too long and I wanted to see if I can shorten it by
cresting subcategories. Another alternative is if there is a way to select a list based on critera, if the value is one, list A is displayed. otherwise List B |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Can I set up sublists under Data Validation
See Debra Dagleish's pages on this:
http://www.contextures.com/xlDataVal02.html -- Regards, Tom Ogilvy "Consulting Joan" <Consulting wrote in message ... My list is getting too long and I wanted to see if I can shorten it by cresting subcategories. Another alternative is if there is a way to select a list based on critera, if the value is one, list A is displayed. otherwise List B |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Can I set up sublists under Data Validation
EXCELLENT - This is exactly what I needed! Thanks for your help.
Joan "Tom Ogilvy" wrote: See Debra Dagleish's pages on this: http://www.contextures.com/xlDataVal02.html -- Regards, Tom Ogilvy "Consulting Joan" <Consulting wrote in message ... My list is getting too long and I wanted to see if I can shorten it by cresting subcategories. Another alternative is if there is a way to select a list based on critera, if the value is one, list A is displayed. otherwise List B |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| custom data validation on cells with data validation values | Excel Worksheet Functions | |||
| Master list with sublists | Excel Worksheet Functions | |||
| Updating Sublists from Master worksheets | New Users to Excel | |||
| data validation invalid in dynamic validation list | Excel Discussion (Misc queries) | |||
| data validation invalid in dynamic validation list | Excel Worksheet Functions | |||
Hybrid Mode
