Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Cell B1 is using data validation referring to a named range. There are 4
possible values: Level 1, Level 2, Level 3, Level 4. I have another named range with the number of days associated with each Level. So, if the user selects Level 1 from the dropdown list in B1, I want the default number of days (10) to be put automatically into B2. If the user selects Level 2 from the dropdown list in B1, I want the default number of days (20) to be put automatically into B2. And the same for Level 3 (30 days) and Level 4 (40 days). I know there is a way to do this, I think by putting the 2 lists next to each other... but I can't remember how to do it! Help! Thanks! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Looks like a comment, but isn't.... what is the yellow box called? | Excel Worksheet Functions | |||
How can i put a picture in the yellow comment box | Excel Discussion (Misc queries) | |||
formula for if Cell c1 is yellow shaded cell d1 should be yellow | Excel Discussion (Misc queries) | |||
IF the cell is yellow... | Excel Discussion (Misc queries) | |||
What is this yellow box? ..Not a comment | Excel Discussion (Misc queries) |