BLANK CELLS

D

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!
 
D

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
 
Top