| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
IF 0 then blanco
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Hybrid Mode
