W
willemeulen
On sheet1 I complete all info displayed spread over other sheets of
which many information is repeated. So I have a direct reference to
sheet1 and only need to complete this information once. My problem is
with the dates for revisions. I only complete a date for the revision
when there is actually one
Sheet 1
Revision No. Issued
1 mar 09
2 apr 09
3
4
etc
When i reference date's directly to empty cells, in this case like for
revision 3 is not done (could or could not be done at a later stage) so
the cell is empty. Now all referenced cells display jan 00, how do I get
around it to let excel display nothing and only show a date when I
actually submitted a date in the mother cell.
Thanks
which many information is repeated. So I have a direct reference to
sheet1 and only need to complete this information once. My problem is
with the dates for revisions. I only complete a date for the revision
when there is actually one
Sheet 1
Revision No. Issued
1 mar 09
2 apr 09
3
4
etc
When i reference date's directly to empty cells, in this case like for
revision 3 is not done (could or could not be done at a later stage) so
the cell is empty. Now all referenced cells display jan 00, how do I get
around it to let excel display nothing and only show a date when I
actually submitted a date in the mother cell.
Thanks