Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Autocomplete date for cell based on other cell values
I have two situations where I want the cell to be filled with a specific
value based on values in other cells on a given row. In the first case I need the CaseID to generate the WorkerID where the WorkerID is determined by the last three digits of the CaseID. In the second I need to have a date placed in the Case Due Column based on two different criteria, if the case is Timely then it would be the last day of the given month, if the item is not timely then the due date is 30 days from the date of application. To determine timely or not first it has to be shown as a review case (two given values on a specific cell) and that it was received prior to the 15th day of the given month due (application received date). I have a general idea of the formula's for both but am unsure of the specific syntax. Is there anyone out there that could help? If needed I can use Visual Basic but would need to know where I would place as I am already running a program with that for conditional formatting of the rows based on progression indicators. Thank you for your help. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Autocomplete date for cell based on other cell values
Maybe you could give a few simple examples
best wishes -- Bernard Liengme Microsoft Excel MVP http://people.stfx.ca/bliengme "Judy Cohen" wrote in message ... I have two situations where I want the cell to be filled with a specific value based on values in other cells on a given row. In the first case I need the CaseID to generate the WorkerID where the WorkerID is determined by the last three digits of the CaseID. In the second I need to have a date placed in the Case Due Column based on two different criteria, if the case is Timely then it would be the last day of the given month, if the item is not timely then the due date is 30 days from the date of application. To determine timely or not first it has to be shown as a review case (two given values on a specific cell) and that it was received prior to the 15th day of the given month due (application received date). I have a general idea of the formula's for both but am unsure of the specific syntax. Is there anyone out there that could help? If needed I can use Visual Basic but would need to know where I would place as I am already running a program with that for conditional formatting of the rows based on progression indicators. Thank you for your help. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Return range of cell values based on current date | Excel Worksheet Functions | |||
Calculate a date based on values in other cell, worksheet | Excel Worksheet Functions | |||
Changing values in cell based on system date | Excel Worksheet Functions | |||
Autocomplete for cell values | Excel Discussion (Misc queries) | |||
VAB to copy cell values into new Sheet, Overwrite if needed and based off of Cell Value in a column | Excel Programming |