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.



Posted by Tom Urtis on September 18, 2001 2:07 AM

At least 2 options for you:

Either try modifying the paste link formula from:
=[Book2.xls]Sheet1!A2
To
=IF([Book2.xls]Sheet1!A1="","",[Book2.xls]Sheet1!A1)

OR

In the destination workbook, try clicking on Tools > Options > View tab, and towards the bottom in the "Window options" section deselect "Zero values".

Tom Urtis