| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Convert regular Date to Week Ending or Week Beginning Dates | Excel Discussion (Misc queries) | |||
| Auto calculate day of week to week of the year (not as serial) | Excel Discussion (Misc queries) | |||
| Tie a Calendar week to a Scoped Projected Week | Excel Worksheet Functions | |||
| How do I set up a week by week skill training schedule in excel? | Excel Discussion (Misc queries) | |||
| I need week number in excell from a date, first week must be mini. | Excel Discussion (Misc queries) | |||
![Shane Devenshire[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Hybrid Mode
