copy?

  • Thread starter Thread starter Liam Keefe
  • Start date Start date
L

Liam Keefe

hi can you help me im trying to copy a formula result from one sheet to
another but it keeps saying =SUM(#REF!) i know im doin it wrong please help

Thanks
 
If you are copying it into another sheet and you don't put
it in the same cell, you may be losing the range. =sum
(a1:a20) in first spreadsheet will not work in next one if
you put the formula in a10 since you lost the range. Or
you could be using a range name in the first sheet that
does not exist in the next? =sum(myrange) where myrange
is in tab 1 but not tab 2.

if you want the result of the formula to appear in your
new sheet, why not reference back to it (so that it will
change dynamically in both sheets when it changes in the
first) tab 2, cell A20 "+tab1!A15"

If you really, really want to copy the formula exactly,
then go to the original cell, hit F2, home, ', enter.
Then copy that to the new tab and then go back and delete
the ' (which signifies text).

HTH.
 
Liam

Do you want to copy the result or the formula?

To copy the result, copy then Edit>Paste Special>Value>OK>Esc.

To copy the formula, first preface it with an apostrophe then copy and take
out the apostrophe.

If you have many, Edit>Replace

What: =
With: xxx

Copy over then undo the edit replace on both sheets.

Gord Dibben Excel MVP
 
Back
Top