Forum Discussion
Repetitive Formulas
Is there a way to copy formulas accumulating totals without retyping each formula. For example we need to total vendor by vendor month by month spending and accumulate those totals in a spreadsheet ...
Attached is the spreadsheet. The last time I hit reply it did not give me an option to Browse. I hope when I hit reply this time it gives me that option.
Hi Michael
To assist, I am uploading the file that you have emailed to me so that others can see it.
As discussed, having looked at the spreadsheet and your requirements, I'm not sure exactly what it is that you are after.
Are you looking to total each of the line items in the Annual worksheet against each calendar month of the year?
I would also suggest not including anymore than 1 calendar year in the spreadsheet, then you can template the spreadsheet and easily adjust for future years.
Talk soon.
Cheers
Damien