I am in a bit of a quandary. I have to produce a spreadsheet with the following output:
Name | Details (the details can be unique to provide lookup ref) | Actual Cost | Cumulative | Budget Cost | Cumulative Budget |
The above is repeated in a pattern 4 week, 4 week, 5 week thus creating a quarterly result
It is then repeated through to the end of the year (ending 31.03.2011)
Because the source data will be store in two separate worksheets under ACTUAL and BUDGET, it is a onerous task developing the look-up references. Is it possible to do it any other way which will simply the Function.
I attach a spreadsheet blank for reference.
Thanks in advance