Beyond Conditional Formatting...

[deepak]

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?

[Peo Sjoblom]

Maybe something like this

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



--

Regards,

Peo Sjoblom


"deepak" <deepak@discussions.microsoft.com> wrote in message
news:DBF3C0DF-CBCC-4765-9E71-50B67ABB835A@microsoft.com...
> 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?