Excel copying with link cells
 

Please can someone help me, I want to copy cells from one worksheet to
another, i have copied the cells concerned and pasted then onto the new sheet
with the paste option link cell. cells thatare blank on the original sheet
are now coming up with a 0 in the new worksheet, how do i stop the 0's being
copied over

Excel copying with link cells
 

Auz

Trap for the zeros which are unpreventable.

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


Gord Dibben MS Excel MVP

On Thu, 27 Apr 2006 09:06:02 -0700, Auz wrote:

Please can someone help me, I want to copy cells from one worksheet to
another, i have copied the cells concerned and pasted then onto the new sheet
with the paste option link cell. cells thatare blank on the original sheet
are now coming up with a 0 in the new worksheet, how do i stop the 0's being
copied over