Linking cells

[careyc]

I'm trying to set up a worksheet where I can type something into one
cell, and the information automatically shows up in another cell that I
designate. I tried using functions, but I get different results.
Basically, I want the designated cell to be blank until something is
entered in the source cell. I was able link the cells by using "=" and
"+" and setting the cell format to "General". However, I get a "0" in
the designated cell when nothing is entered in the source cell. Is
there a better way?

Thanks in advance!

 

[Dave Peterson]

=if(a1="","",a1)
or
=if(sheet2!a1="","",sheet2!a1)

 

[careyc]

Thanks was very helpful, thanks