cell reference problem - help!!!!

  • Thread starter Thread starter dz
  • Start date Start date
D

dz

I have a formula similar to the following:

=(E2+F1)

When I copy the row and paste it below the previous entry,
the reference correctly changes to: =(E3+F2). No matter
how many rows I copy/add under the previous entry, it
always correctly recalcs the references.

However, if I paste the row between two entries, it does
the following:

Row 2 = =(E2+F1)
Row 3 = =(E3+F1) - it should be (E3+F2)
Row 4 = =(E4+F3)

I also tried using the R1C1 reference style under tools,
options, general, but it still incorrectly "fills" row 3.

Does anyone have any ideas? I'm desperate. Thanks.
 
Hi DZ,

Instead of copying and pasting the formula, drag it down. For example, in
cell D2 you type in =E2+F1 and then press Enter. Click back into cell D2
and at the bottom right hand corner you'll see that there is a little black
cross. Hover your mouse over it and it will turn into a + Click and drag
that formula down and it will automatically adjust so that D3 contains the
formula =E3+F2.

HTH,
Katherine
 
DZ

This problem will arise if you Cut and Paste. If you Copy and Paste you
should not see the duplication.

Gord Dibben XL2002
 
Thank you both for your response. However, the row is
programmically copied to the current location (although
the problem occurs whether or not the macro is used).

So, I cannot do the "hover" thing, and it IS copied, not
cut.

Any other suggestions? Thanks.
 
Back
Top