cut & paste made the cell with forumla #ref

[Ms_M_o_n_i_c_a]

how do i stop this from happening?

example: a1 equals a2 but when I cut from a3 and paste to a2, a1 turns into
#ref.

i want a1 to equal a2 no matter what

I seen a thread on this the other day and thought i printed it

 

[Max]

Do instead a copy n paste special as values. Copy A3, then right-click on A2

Paste special > Check "Values" > OK. It won't mess up your formulas.

--
Max
Singapore
http://savefile.com/projects/236895
Downloads:16,700 Files:356 Subscribers:53
xdemechanik
---

 

[Ms_M_o_n_i_c_a]

I preparing this spreadsheet for sharing. everyone else wont know that. is
there another way?

 

[Max]

I'm still sticking to your subject line. For any formulated set-ups, these
can be easily & badly destroyed/messed up if you practise row/col deletions,
cell/range cut n pastes, etc, where the precedents/dependents in the
formulas point to the very row/col/cell/ranges that are impacted.

The simple precaution is hence, not to do any of these things.
--
Max
Singapore
http://savefile.com/projects/236895
Downloads: 16,400, Files: 356, Subscribers: 53
xdemechanik

 

[Max]

OTOH, if this statement of yours is key
Then
in A1: =IF(INDIRECT("A2")=0,"",INDIRECT("A2"))

Or, if you need to propagate it across from A1,
use this in A1
=IF(OFFSET(INDIRECT("A1"),1,COLUMNS($A:A)-1)=0,"",OFFSET(INDIRECT("A1"),1,COLUMNS($A:A)-1))
then copy A1 across to return correspondingly from row2
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:16,700 Files:356 Subscribers:53
xdemechanik
---

 

[Ms_M_o_n_i_c_a]

THANKS. i worked. now i just need to figure out how to copy forumula without
changing the reference

 

[David Biddulph]

If you want to copy a formula without it changing the reference, have you
looked at the difference between absolute and relative addressing?