View Single Post
  #1   Report Post  
PAUL GRAZIDE
 
Posts: n/a
Default copying content of cell automatically to multiple cells

How do I enter a number once and have it copy automatically to multiple
cells. I tried formatting the cells as text and using the =T() function.
This worked fine for the first copy but not for the 3rd and 4th copy. What
is the correct way to do this?

a1 k2 m2
123 =t(a1) =t(a1) ......etc k2 is ok, other no data just
the formula

thanks in advance