The workbook I have attached shows a template ( yellow) that my app copies 12 times onto a worksheet (January shown on this illustration).
The problem that I have is how to deal with the formulas that I would like to add to the YEAR TO DATE half of the template which would sum up the previous YTD with the current value.
I have to deal with the fact that December (the first month) is different from all the others as it has nothing to sum to. Secondly that a formula in the template would need to refer to negative column numbers and I don't think Excel allows those.
Is there a way to use the template which I would prefer or do I have to do something in the completed year sheet?
John
Bookmarks