IF 0 then blanco

M

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Using Fill to copy from other sheets 8
select file from which to extract specific data 3
Move/Copy sheet to another workbook error 2
Auto Copy Data from one worksheet to another 1
loopkup part of a name or number 2
Still Another Copy-and-Paste Macro Problem 3
copy rows from one Data sheet to another sheet based on cell conte 2
Help to create a macro 2

Top