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

You do it like this:

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

Regards, Fred

"mariekek5" wrote in message
...
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

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;;@


--
NBVC

Where there is a will there are many ways.
------------------------------------------------------------------------
NBVC's Profile: http://www.thecodecage.com/forumz/member.php?userid=74
View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=109721

Great, thanks Fred.

"Fred Smith" wrote:

You do it like this:

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

Regards, Fred

"mariekek5" wrote in message
...
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