Use absolute references, $A$1 as opposed to A1, if copying to another workbook
copy the formula from the formula bar, if there are multiple formulas,
do editreplace and replace = with q=, copy all you want to the new worksheet,
when done do a reverse replace and replace q= with = in both sheets

Regards,

Peo Sjoblom


"judyskiskd" wrote:

How do you link an ending balance in one worksheet so that it becomes the
beginning balance in another worksheet without messing up the formulas