Forum Discussion
Excel formula help... again!
TOTALLY concur with m_tarler : it's generally a design mistake (in the sense that it makes things more complicated and is more error prone) to have a separate sheet for each month. This often happens because people carry-over the ledger sheet mentality to Excel, rather than taking advantage of Excel's superior ability to work from a single comprehensive datatable, producing monthly reports as needed, but also readily showing current status--whatever you want.
Are you open to reconsidering your design? If so, please give us a more complete picture of the application, ideally including an anonymized copy of the actual workbook.
No the values does not increase, it differs, there are a few calculations I have on each cell already.
And the different sheets is just to organize it better for the client I'm trying to help.
I'll send a screenshot of what it is I'm working with:
calculations include - each cows dried off cell deducts from cows in milk (CIM) and each dry cows calved adds to CIM again.
the total in the yellow block on the right needs to be the starting total for the next month in the opening balance as the calculations add and subtract again for the next month.