How do I set a formula in a cell to equal the total in another ce.
 

I have to enter an opening amount for a day that equals the closing amount of
the previous day.

hi,
if the other cell in on the same sheet,
assuming the closing amount is in cell say c27...

=C27

if the other cell is on a different sheet say sheet 1...

=sheet1!C27


-----Original Message-----
I have to enter an opening amount for a day that equals
the closing amount of
the previous day.
.