linking sheets in the workbook and getting rid of the ZERO
=IF(Sheet1!A1="","",Sheet1!A1) in a cell on Sheet2
keeps the cell blank until a value is entered in A1 of Sheet1
Gord Dibben MS Excel MVP
On Wed, 30 Jan 2008 08:26:05 -0800, mschulze
wrote:
Ok. I am thinking this is a format problem, but when I go to link sheets in
the workbook and copy one sheet to the other, I am getting a zero in the
columns. For example when I enter a number 3 on sheet 1 and want it to go to
sheet 2, no problem, but when I enter a number 5 cells below in the same
column on sheet 1, sheet 2 has zeros going from the previous number 3 down to
the rencently entered number. How do I eliminate this on sheet 2?
|