|I believe what the original post was trying to say , is also the exact problem I am having. He is trying to create a spreadsheet to compile YTD "Year to date" MTD "Month to date" and WTD "Week To Date" for financial information. |
I apologize for the "explanations of abbreviations" just trying to be perfectly clear :)
I am running into the same problem, at work I had Excel thrust upon me and was told I had to learn it and convert all of my previously hand written reports onto a automated report that can be filled out by anyone.
The problem is a lack of knowledge on my part:
I have created a work book that has 3 sheets titled WTD, MTD, YTD
WTD: has basic =SUM() functions that add up and calculate all revenue's for the operations and register totals for my work.
MTD: is using functions to take the week totals from my WTD Sheet using the =SUM (WTD!WTDTOTAL) function and is supposed to place them in the Week1 through Week4 Columns, which are then subjected to formulas to compare them to previous year totals for that month.
YTD: is to take the totals from the sheet MTD using the =SUM(MTD!MTDTOTALS) function and place them in YTDTOTAL
The problem I am having as was the previous poster, is at the end of each week all of the cells used to calculate all of the WTD totals on the first sheet has to be reset (deleted) for the new week numbers to be input, and the functions I am using do not save the previous information into a separate cell that shows a running total, instead all the calculations are lost.
Each sheet works great individually, if I had supervisors that were happy with someone just manually inputting the information each week/month onto the next sheet.... but they don't want that. Is there a template or a tutorial that I can be directed too, or is there a simple function example I can use to get the running totals in a final cell that doesn't disappear when the cells used to get the total are emptied?