Maybe just try a cut and paste ?
Right-click on the cell with the formula in Sheet1 > choose Cut
Click on Sheet2's tab, then right-click on a target cell inside > Paste
--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <at>yahoo<dot>com
----
Patrick <moonstar0011@hotmail.com> wrote in message
news:110b254e4rtedf2@corp.supernews.com...
> I have a formula on Sheet 1.
>
> Can I move the cell that shows the total of the formula from sheet 1 to
> sheet 2, so that any changes in the data, on sheet 1, would show up on
Sheet
> 2 in the total box? Can't quite figure it out.
>
> Thanks,
>
> Patrick
>
>