I have a worksheet that gets a date from another worksheet and displays it in
a cell.
I want it to only update if another cells value is "Y", If the cells value
is "N", I want it to leave the displayed date the way it is and not update
the date from the other sheet. I have used an "IF A1=Y(formula)" but it
doesn't leave the exsisting date displayed. I don't want to use iterations
either because that would affect the other formulas I think.
Any suggestions gratefully accepted.