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

Thanks for the reply and concern Mynda

As You enter a detail and the code say, code 100 and the amount spent (500), it should automatically appear "I4". Same with other enteries.

After all entries have been made for september, the BALANCE CARRIED should automatically appear as brought forward for the month of OCTOBER.

The "ALL MONTHS" Sheet just shows the total summary spent for each month. The ANNUAL SHEET details the sum total of all the months.

Hi Meyanui

Please refer attachment. 

I would recommend you follow Mynda's advice and capture your data in a tabular format. It will be easier to summarise and analyse using PivotTable.

Sunny

Thanks Sunny. I very much appreciate the formula for the entries

Kind regards.

Meyanui