How to link endings balances to beginning balances on different sh

J

judyskiskd

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
 
P

Peo Sjoblom

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 edit>replace 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
 
Top