I'm working on a Project Summary workbook, containing a "Dashboard" sheet
(which displays a snapshot of the most recent project data), and 4 other
sheets: Project Scope, Project Status, Project Change and Project Closure.
The Project Manager wants to enter the "Approved Finish Date" into cell A on
the Dashboard page at the start of the project, but if this date changes, the
PM will enter the changed Approved Finish Date into cell B on the Project
Change sheet. I need your help to write a formula that allows the PM to hard
key a date into cell A, and still allows cell A to pull data from cell B to
replace the hard keyed data in cell A. Is this function possible? If yes,
please help me with the formula.