There is no formula that can reference amounts that are no longer in the
workbook. Your clearing macro should append amounts you don't want to lose
to a list elsewhere in the sheet.

--
Jim
"the holster" <the wrote in message
...
|I have successfully created a 'Clear Contents' button for a worksheet, so
| that a new form can be started from scratch. However, I need to keep the
| running balance from the previous week on the new sheet. If I clear the
| entries, the running balance will also change. What formula can I use so
as
| to duplicate the true running balance total to the new sheet?