cut & paste made the cell with forumla #ref
 

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
--
I will Excel at Excel!

cut & paste made the cell with forumla #ref
 

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" wrote:
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
--
I will Excel at Excel!

cut & paste made the cell with forumla #ref
 

I preparing this spreadsheet for sharing. everyone else wont know that. is
there another way?
--
I will Excel at Excel!


"Max" wrote:

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" wrote:
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
--
I will Excel at Excel!

cut & paste made the cell with forumla #ref
 

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
---
"Ms_M_o_n_i_c_a" wrote in message
...
I preparing this spreadsheet for sharing. everyone else wont know that. is
there another way?
--
I will Excel at Excel!

cut & paste made the cell with forumla #ref
 

OTOH, if this statement of yours is key
.. i want a1 to equal a2 no matter what

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

cut & paste made the cell with forumla #ref
 

THANKS. i worked. now i just need to figure out how to copy forumula without
changing the reference
--
I will Excel at Excel!


"Max" wrote:

OTOH, if this statement of yours is key
.. i want a1 to equal a2 no matter what

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

cut & paste made the cell with forumla #ref
 

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

"Ms_M_o_n_i_c_a" wrote in message
...
THANKS. i worked. now i just need to figure out how to copy forumula
without
changing the reference
--
I will Excel at Excel!


"Max" wrote:

OTOH, if this statement of yours is key
.. i want a1 to equal a2 no matter what

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