Cut and Paste gives a #Ref error in Cell

[Mark]

I have three columns for each month, in first column I have the sales, in
second column I have adjustments, in third I have comments. At the end of
the role I have +A1+B1+D1+E1 and so on, skipping the column with the
comments. If I cut and paste a group of cells, for example A2, B2, and C2
and paste them in A3, B3, and C3 I end up with either in roll 2 +A3+B3+D2+E2,
when it should be +A2+B2+D2+E2, or a #Ref error. I have tried using the
absolute, +$A$2+$B$2.... and that doesn't work. Any ideas out there on this?

Thanks,
Mark

 

[CLR]

Try COPY and Paste, and then Delete the undesired, rather than CUT and
Paste.........

Vaya con Dios,
Chuck, CABGx3

 

[jlclyde]

I have three columns for each month, in first column I have the sales, in
second column I have adjustments, in third I have comments.  At the end of
the role I have +A1+B1+D1+E1 and so on, skipping the column with the
comments.  If I cut and paste a group of cells, for example A2, B2, and C2
and paste them in A3, B3, and C3 I end up with either in roll 2 +A3+B3+D2+E2,
when it should be +A2+B2+D2+E2, or a #Ref error.  I have tried using the
absolute, +$A$2+$B$2.... and that doesn't work.  Any ideas out there on this?

Thanks,
Mark

Here is how the relative reference works. If you copy and paste a
formula from one point to another excel changes the formula the number
of rows and number of columns. If you want to keep any part of the
formula the same you need to put in a $ in front of it. For example
if you have $A1. No matter where you wove this cell it will always
look at Column A. If you have A$1. No matter where you move this
cell it will ahve a reference to Row 1. If you have $A$1. It will
always be A1. According to what you have written, there is no need to
copy and paste, you should just be able to drag the cell down.
Jay