Beyond Conditional Formatting...
 

Is it possible to have the content of one cell in a row dictate the content
of the following cells? For instance, if you chose answer A from a dropdown
in the first cell, could you display one set of dropdowns in the other cells
in that row, and then display another set of dropdowns if you chose answer B?

Beyond Conditional Formatting...
 

Maybe something like this

http://www.contextures.on.ca/xlDataVal02.html



--

Regards,

Peo Sjoblom


"deepak" wrote in message
...
Is it possible to have the content of one cell in a row dictate the
content
of the following cells? For instance, if you chose answer A from a
dropdown
in the first cell, could you display one set of dropdowns in the other
cells
in that row, and then display another set of dropdowns if you chose answer
B?