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.
|