I need to use the same fomula each week after saving
 

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

I need to use the same fomula each week after saving
 

Do you not just want to clear the Mileage cells?

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


--
Stringer
------------------------------------------------------------------------
Stringer's Profile: http://www.thecodecage.com/forumz/member.php?userid=117
View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=64466

I need to use the same fomula each week after saving
 

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

"Stringer" wrote:


Do you not just want to clear the Mileage cells?

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


--
Stringer
------------------------------------------------------------------------
Stringer's Profile: http://www.thecodecage.com/forumz/member.php?userid=117
View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=64466

I need to use the same fomula each week after saving
 

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.
--
If this helps, please click the Yes button

Cheers,
Shane Devenshire


"upit" wrote:

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