I am trying to put together a template for project costs and am looking for a way to roll forward daily costs for each account code that avoids the need to change the formula on a daily basis.
I have all my account codes in column A then total daily costs in columns C/E/G etc for day 1/2/3 etc (Columns D/F/H have the calulation for that day's costs). Is it possible to put the current project day in a cell at the top of the 'cost to date' column and use this to pick up the costs for those days? ie
day 2 = C2+E2 day 3 = C2+E2+G2 day 4 = C2+E2+G2+I2
If it was just for me I'd be lazy and add each day as I went but as it's a template for general use I thought it would be useful to automate as far as possible.
Any help greatly appreciated Thanks Ian