G
Guest
When creating worksheets, you often need to copy a specific function from one
area to another in the same worksheet (or to another), without changing the
original formulas. This is not possible as a 'paste special funtion'.
When copying formulas in 'paste special' mode, the relative references in
the formula are still changed. In short, when copying the 'formula' =A25' to
another cell, the formula in the copy to cell should still be '=A25'.
Suggestions of changing the orginating formula from relative to absolute
reference (e.g. $A$25) before copying doesn't solve the problem, since the
originating cell MUST have a relative reference (A25 instead of $A$25).
Any suggestion or functions, that I have overlooked, - or is this a
functionality lacking of Excell??
area to another in the same worksheet (or to another), without changing the
original formulas. This is not possible as a 'paste special funtion'.
When copying formulas in 'paste special' mode, the relative references in
the formula are still changed. In short, when copying the 'formula' =A25' to
another cell, the formula in the copy to cell should still be '=A25'.
Suggestions of changing the orginating formula from relative to absolute
reference (e.g. $A$25) before copying doesn't solve the problem, since the
originating cell MUST have a relative reference (A25 instead of $A$25).
Any suggestion or functions, that I have overlooked, - or is this a
functionality lacking of Excell??