I have a two sheet work in which Sheet2 shows all the administrative data and Sheet1 shows only the data an employee would need to know. Sheet1 contains multiple countdown dates pulled from Sheet2. What I would like to do is continue to have Sheet1 pull forward the countdown dates from Sheet2.... But, once the the employee completes the item and is updated on Sheet2, I want Sheet1 to replace the countdown date with specific text such as "Received" or "Closed" and if possible, in the same cell, bring forward the date on Sheet2.
The attached is just an excerpt from the much larger workbook.
Bookmarks