PasteLinking - I don't want to use or display a default value in destination cell
Posted by Kelwyn Yeo on September 18, 2001 1:42 AM
Hi I need help with this:
I have paste linked dates from several sources to compile onto a summary sheet. If the source cell is empty, the destination cell shows as 0/01/00 (as this is the date format of the cell I want). As some of the source dates will not be entered, the minimum date in my summary sheet will therefore be 0/01/00.
Is there a way to calculate the minimum date, to ignore the value if it is 0/01/00 in the destination cell. Better still, when paste linking, if the source cell is empty, can the destination cell also display as empty rather than a 0 or value. That way calculations will not include these paste linked default values.