In cell B1 I have four options in a drop down menu...

Rich
Lean
Flash
Other

In cell B2 I have two options in a drop down menu...

uncontrolled
controlled


Each combination (Rich&Uncontrolled, Lean&Uncontrolled
Rich&Controlled, etc.) except "other" should populate cells B13 to B2
with specific numbers. If they choose other, then B13 to B26 should b
left blank for user input.


Any ideas. It seems like an if-then problem, but I am not advanc
enough at VB to know how it can be done.


Many thanks

--
Message posted from http://www.ExcelForum.com