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