How to repeat numbers in different cells?

H

HWDijkhuizen

If I fill in a number in one cel I want it automaticly repeated in another,
specified cel. How can I do that?
 
D

Dave Peterson

If you type the number in A1, you can use:
=A1
or
=if(a1="","",a1)
in a cell on that same sheet

In a different sheet:
=sheet1!a1
or
=if(sheet1!a1="","",sheet1!a1)
 
Top