IF 0 then blanco

[mariekek5]

Hi, I would like to copy a whole column from one sheet to another. When in
the source sheet new data will be entered, then automatically this new data
(new rows) will also appear in the destination sheet.

I use: =sheet!A1 etc...

The rows not containing any data in the source sheets, give me zero's in the
destination sheet. Is it possible to make blanco cells, instead of getting
zeros?

Thanks in advance.

Marieke

 

[NBVC]

You can also keep the formula you have and "hide" the zeroes...

Go to Tools|Options and in the View tab, deselect Zero Values.

or you can format the cells with Custom: 0;-0;;@

 

[mariekek5]

Great, thanks Fred.

You do it like this:

=if(sheet1!a1="","",sheet1!a1)

Regards, Fred