I have inherited a workbook which is being used to track differences between forecasted savings and actual savings on a monthly and year to date basis. See attached sample, I have removed the financial data but the formulaes remain.
The problems I have are with the formulae used in the summary page. They seem very cumbersome and there must be a simpler way to "pull" the data through.
Where I am struggling is that the individual worksheets are not a standard layout therefore I'm not sure how to reference the various cells in the summary sheet to the individual workshets.
Each month a new workboook is created by copying the old renaming it to the current month and changing the cell references.
Any help would be appreciated.
Bookmarks