This seems simple but i'm stumped.
I have a change order document with a summary page on the first sheet and subsequent change order sheets.
I've linked the sheets so that data entered in the summary sheets appears in the change order sheets and vice versa.
On the summary sheet, I want the date from each active change order sheet to appear in a specific cell.
The easy way to do it is to link the date cell on a change order sheet with the cell in which I want the date to appear on the summary sheet. This works fine when there is a date in the change order sheet. However, if I have only activated some of the change order sheets, the summary sheet returns a date of "January 1, 1904" in all the cells that correspond to inactive (blank) change order sheets.
Question, how do I get the summary sheet to display a blank cell when there is no date in the target cell?
Thank you,
Tim
I have a change order document with a summary page on the first sheet and subsequent change order sheets.
I've linked the sheets so that data entered in the summary sheets appears in the change order sheets and vice versa.
On the summary sheet, I want the date from each active change order sheet to appear in a specific cell.
The easy way to do it is to link the date cell on a change order sheet with the cell in which I want the date to appear on the summary sheet. This works fine when there is a date in the change order sheet. However, if I have only activated some of the change order sheets, the summary sheet returns a date of "January 1, 1904" in all the cells that correspond to inactive (blank) change order sheets.
Question, how do I get the summary sheet to display a blank cell when there is no date in the target cell?
Thank you,
Tim
