drop down menu
 

I would like to have a drop down menu option for a cell.
However, the choices will determine what data is entered
into another cell. For example: menu options X Y Z, if
user picks X then 12 goes into cell d35, 13 goes into d36
and 14 goes into d37. If option Y is chosen, then 11 goes
into d35, 34 goes into d36 and 54 goes into d37
and so on ...
Thanks in advance for your assistance.
Susan

drop down menu
 

Susan,

Select the cell and goto Data Valiadation
under Allow: select List
under Source type X, Y, Z

Check out all the other options and make any selections you want.

If your validation cell is D34
In D35
=If(D34="X",12,If(D34="Y",11,If(D34="Z",10,"")))
Put similar formulas in D36 and D37.
Note that the final option is "" so that these cells remain blank if nothing
is selected.

steve

"Susan April" wrote in message
...
I would like to have a drop down menu option for a cell.
However, the choices will determine what data is entered
into another cell. For example: menu options X Y Z, if
user picks X then 12 goes into cell d35, 13 goes into d36
and 14 goes into d37. If option Y is chosen, then 11 goes
into d35, 34 goes into d36 and 54 goes into d37
and so on ...
Thanks in advance for your assistance.
Susan

drop down menu
 

Steve,
Thanks...That's it.....this should work.
Susan

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

drop down menu
 

Susan,

You're very welcome!

Glad I could help.

steve

"Susan April" wrote in message
...


Steve,
Thanks...That's it.....this should work.
Susan

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!