Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How do I lock a cell automatically after it has data entered. | Excel Discussion (Misc queries) | |||
Sorting cell data based on values | Excel Discussion (Misc queries) | |||
How to lock a row in a spreadsheet based on the value in a cell | Excel Worksheet Functions | |||
Help PLEASE! Not sure what answer is: Match? Index? Other? | Excel Worksheet Functions | |||
GET.CELL | Excel Worksheet Functions |