Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hello,
I have chart with headings as follows: Name Skill Status In Train Date Qual Date Cert Date What I have been asked to to is as follows: I created a list for the status. 3 options In Train, Qual, Cert. When the training focal point selects In Train I need the current date to be entered into In Train Date column. Then when the focal point changes Status column to Qual, I need the in Train Date column to remain as original date, and then the current date to be put in the Qual Date column, and same for Cert Date. Also if the status is change to a blank(operator left) want to clear the dates. Hope thats not too confusing to understand. Thanks in advance for your assistance CrimsonPlague29 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Jump to a different cell depending on list selection | New Users to Excel | |||
Locking cell depending on outcome of formulae | Excel Discussion (Misc queries) | |||
VLOOKUP or dropdown in the cell depending on selection in another | Excel Discussion (Misc queries) | |||
Dynamically locking a cell depending upon value of another cell. | Excel Discussion (Misc queries) | |||
Lock data in a cell a specific cell based on selection on other ce | Excel Worksheet Functions |