Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
SUM formula for different sheets
How to keep the same formula value when you copy a column to different sheet?
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Formula between sheets. | Excel Worksheet Functions | |||
Formula across multiple sheets | Excel Worksheet Functions | |||
Formula from various sheets | Excel Discussion (Misc queries) | |||
Using Data From Different Sheets Via Formula/ae | Excel Discussion (Misc queries) | |||
Help! Formula between the sheets | Excel Worksheet Functions |