I am making a table for outcomes but I don’t know how to make my idea reality.
I want to have 2 sheets. First sheet is where to write the outcomes and it should looks something like this:
On the second sheet is where it comes hard. The sheet should looks like that:
I want to input the date (month) and automatically to sort my outcomes by type and after that to calculate the total values.
Could you please give me some directions?
I want to have 2 sheets. First sheet is where to write the outcomes and it should looks something like this:

On the second sheet is where it comes hard. The sheet should looks like that:

I want to input the date (month) and automatically to sort my outcomes by type and after that to calculate the total values.
Could you please give me some directions?