There are cells to enter receipts - Month, Day, Category, Item, Amount
Category is a predetermined list of expense categories.
To the right of these cells is a column of cells listing the number and category mentioned above.
To the right of that is a month grid. Jan - Dec along the top.
As items/receipts are entered I want the item be placed under the correct month and along the correct category. As items are entered the Amount needs to be added to any amount in a cell next to the categories.
File attached -
Jan 1 receipt amount should be listed under Jan column next to category 1
Feb 2 receipt amount should be listed under Feb column next to category 2
Mar 3 receipt amount should be listed under Mar column next to category 3
Mar 6 receipt amount should be listed/added to the Mar column amount next to category 3.