Updating excel from a word file
Sheets("Prior Week") Set sh Pivot = Active Workbook.
Updating the vehicle log on daily basis will also give you the true value of your asset by the end.
This can be easily done with the help of vehicle log template.
It is a very easy way to provide the good security to your dear ones.
Note that when you "paste" the selection into Word, if you right click to enable the paste, instead of just using CTRL V, you'll have the option of selecting the style of selection to match the original, or match the Word docment style.
If you want to continue to "do math" in your Word Document (in this example, perhaps updating the sales figure and re-calculating the average), you can actually insert the spreadsheet as an Excel object.