Hi Steve

=IF(Sheet2!A1="","",Sheet2!A1)

Regards

Roger Govier


steve wrote:
i have linked some cells in excell to another work sheet but if sheet 1 has
no data in the cell then sheet 2 shows a 0 how do i keep the linked / watched
cell but not return the zero on the second sheet.??