I need to use the same fomula each week after saving

  • Thread starter Thread starter upit
  • Start date Start date
U

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
 
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
 
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.
 
Back
Top