I am assuming that your question is prompted by Excel's attempt to be
helpful by creating links and/or making automatic adjustments to
formulas when you copy and paste between worksheets and workbooks. If
my assumption is correct I have a method that I use to keep the
function from being "adjusted" by Excel. There are probably other
(better?) methods, using Paste Special or such, but I have good
success by doing a copy and paste using just the text portion of the
formula as it displays in the top formula bar.
Step by Step:
In the copy from worksheet,
have the formula bar showing (View - Formula Bar,
single click on the cell that contains the function to be copied,
click on the formula bar and highlight the formula EXCEPT for the equal
sign,
copy the highlighted formula text using your favorite method (Ctrl-C
or Edit - Copy),
PRESS ESCAPE to make Excel stop paying attention to what you are doing
with the copied text,
then switch to the worksheet where you want to copy the formula to,
click on the cell where you want to place the formula,
press the equal (=) key,
paste the formula text (Ctrl-V or Edit - Paste)
If necessay, make any changes to the formula text,
Press <Enter

This sounds like a lot but actually is very quick once you get used to
it.



tjstoma wrote:
Can you copy a cell and function from one worksheet and copy to a cell on
another worksheet?