Home |
Search |
Today's Posts |
#1
|
|||
|
|||
updating data daily for a wk/month total
Hi! I have a workbook set up to import the previous days business results.
However, the worksheets also show the total for that week, month, and year (these #s are not the last 7days or 30days or 365days, but the results so far of that week, ie Mon being 1st day & Sun being the 7th day). As of now, I am manually adding the days results into the week, month, and yr cells, but this is a massive daily project. Is there a function (or something) that would add today's numbers to yesterday's total wk/month/year numbers? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to have total for filtered data?? | Excel Discussion (Misc queries) | |||
Updating calculations automatically when i enter in new data | Excel Discussion (Misc queries) | |||
Pulling data from 1 sheet to another | Excel Worksheet Functions | |||
My Pivot total just repeats item data | Excel Discussion (Misc queries) | |||
Daily Macro to Download Data, Order and paste in order | Excel Worksheet Functions |