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?