Two validation cells populated third validation
 

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

Two validation cells populated third validation
 

trying to learn this... Why are the cells not populated when I type Ric
into cell C5??

Thank you

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

Two validation cells populated third validation
 

Forgot to paste the code...

Sub Populate()
'
' Populate Macro
' Macro recorded 6/9/2004 by sowetoddid
'

'
If Range("C5").Cells = "Rich" Then
Range("C10").Cells = 1
Range("C11").Cells = 2
Range("C12").Cells = 3
End If


End Su

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