| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Validation lists that change based on a selection from another lis
As my subject line implies, I am trying to figure out how to change a
validation list based on a selection (or selections) from another validation list. I found a resource that shows how to do it for 2 list, but I have 3 list and one of them is based on the selections from the other two. So what I need help with is how to setup a validation list that changes based on the selections from two other validation lists. Any help will be greatly appreciated. This is a top priorty for us right now. Thank you. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Validation lists that change based on a selection from another lis
Might be something here at Debra's site that you could use.
http://www.contextures.on.ca/xlDataVal02.html#TwoWord Create a two-word DV list then have a dependent list off that. http://www.contextures.on.ca/xlDataVal02.html which is probably the "resource" you found. Gord Dibben MS Excel MVP On Thu, 21 Feb 2008 16:17:01 -0800, Ayo wrote: As my subject line implies, I am trying to figure out how to change a validation list based on a selection (or selections) from another validation list. I found a resource that shows how to do it for 2 list, but I have 3 list and one of them is based on the selections from the other two. So what I need help with is how to setup a validation list that changes based on the selections from two other validation lists. Any help will be greatly appreciated. This is a top priorty for us right now. Thank you. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Validation lists that change based on a selection from another
Thanks Gord,
That was very helpful. "Gord Dibben" wrote: Might be something here at Debra's site that you could use. http://www.contextures.on.ca/xlDataVal02.html#TwoWord Create a two-word DV list then have a dependent list off that. http://www.contextures.on.ca/xlDataVal02.html which is probably the "resource" you found. Gord Dibben MS Excel MVP On Thu, 21 Feb 2008 16:17:01 -0800, Ayo wrote: As my subject line implies, I am trying to figure out how to change a validation list based on a selection (or selections) from another validation list. I found a resource that shows how to do it for 2 list, but I have 3 list and one of them is based on the selections from the other two. So what I need help with is how to setup a validation list that changes based on the selections from two other validation lists. Any help will be greatly appreciated. This is a top priorty for us right now. Thank you. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Dynamic drop-down lists based on an initial value selection | Excel Discussion (Misc queries) | |||
| How to clear validation lists based on other validation lists | Excel Discussion (Misc queries) | |||
| validation list - filter based on selection | Excel Worksheet Functions | |||
| change font to validation drop lists | Excel Worksheet Functions | |||
| Drop Down Lists - assign a value based on selection | Excel Worksheet Functions | |||
Linear Mode
