Monthly Accounts to Annual Summary | General Excel Questions & Answers | Excel Forum

Hi Meyanui,

I suspect the reason you haven't had an answer to your question yet is because you haven't been clear in your requirements. You say "I need formulas that will help such that when I enter a code and the amount it automatically registers the value in its respective cell." but you haven't said what cell you want to enter a code into, nor given an example of the code, or the amount it would automatically register and where. In the workbook there aren't any examples either.

Please provide a couple of examples in a revised workbook so we know what you expect to see and where.

Secondly, the layout of this workbook is not ideal for summarising. It may be easy to enter data into, but that's at the expense of being able to easily analyse and summarise that data. You should be aiming to capture your data in a tabular format and the create the monthly report sheets and summary from that. More on tabular data and why you should be using that format here: https://www.myonlinetraininghub.com/excel-tabular-data-format

Kind regards,

Mynda