Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Combo box list depends on value
Hi there
We have a sheet that allows people to select items from a list. Each item they pick has a value associated. There are 6 rows of this, then a total appears. The next combo box list text depends on the total from the previous choices. If they score from 0-6 the first list should appear, from 7-12 a different list appears etc How can we do this? At the moment we are using Excel 2003 and Data Validation Lists, but not sure if this will do what we want. Regards, Neal. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
dynamic combo boxes | Excel Worksheet Functions | |||
Drop down list or combo box help needed | Excel Discussion (Misc queries) | |||
Extracting Values on one list and not another | Excel Discussion (Misc queries) | |||
How do I find out what items are in one list but not in another l. | Excel Discussion (Misc queries) | |||
Creating a list from an existing list. | Excel Worksheet Functions |