I need to use the same fomula each week after saving

[upit]

I want to create a mileage calculator daily Mon – Sun
Start 1222
First, call 6
First to last 52
Last 9
Finish 1289
Total 67 over 7 days then on new week open clear formula

 

[Stringer]

Do you not just want to clear the Mileage cells?

You can save the Template workbook as a template, then when you want t
add a new workbook, File=>new you should be able to select the templat
workboo

 

[upit]

Do you not just want to clear the Mileage cells?
Than you for your reply
Yes I Do but not my formulas ‘in the total fields
What I am trying to achieve is on the start I have blank template at the
start of each week and I want to copy the finish mileage to the start on each
day

 

[Shane Devenshire]

Hi,

If I understand correctly, at the beginning of each day you should select
the formula in the Finish cell and copy it. Select the Start cell and choose
Edit, Paste Special, Values. Clear the contents of First call, First to Last
and Last.
You could automate that with a macro, but its pretty easy to do manually.