BLANK CELLS

[Deidre]

i have 2 different worksheets in which i in the second one, in one cell, i
want to equal what is in the first worksheet. but if the cell is blank i want
it to be blank in the second worksheet as well. it keeps giving me a zero.
how do I make it just a blank cell?
thanks!

 

[Bill Kuunders]

oops
don't worry about the book name

try this

=IF(Sheet3!D1="","",Sheet3!D1)

 

[Deepali Joshi]

Hi,

Select data, copy it.

Edit-->Paste Special. From Paste Special dialog box select skip blanks
option, click OK

This will surely work

Deepali Joshi