SUM formula for different sheets
 

How to keep the same formula value when you copy a column to different sheet?

SUM formula for different sheets
 

CopyPaste SpecialPaste Link


Gord Dibben MS Excel MVP

On Thu, 18 Jun 2009 12:14:02 -0700, Chow
wrote:

How to keep the same formula value when you copy a column to different sheet?

SUM formula for different sheets
 

Hi,

Not sure what you want - to copy the formula or to copy the value?

In any case select the formula and copy it, move to the other spreadsheet
and choose Edit, Paste Special, Values.

Now if you are trying to copy the formula we would need to know what you
want the result to be - a formula that refers to the original spreadsheet or
to an identical range in the current file.
--
If this helps, please click the Yes button.

Cheers,
Shane Devenshire


"Chow" wrote:

How to keep the same formula value when you copy a column to different sheet?