I have attached and expample file of what i'm trying to do as i'm not sure i will be able to explain this cleary. I am a total rookie when it comes to using the formulas in Excel but i am trying to learn and know that this is a powerful software and can do so much.
Anyway, i am trying to auto-populate a seperate box from entries that i make. Example is trying to track monly expenditures. In the attached, I enter the date, enter the item (expenditure) in the blue column and then enter debit amount in the orange column. These items are tracked throughout the month and this is the only area i want to have to enter data. In the box next to it i have identified categories of how debits are tracked and i have to manually pick the cells in the box to the right to show me a total of this category highlighted in yellow.
My objective is i want to only have to enter data as a category in the blue highlited column, i.e., "Groceries (Target)" and enter the dollar amount in the orange column, i.e., "$24.71" and have it auto-populate in the appropriate box to the right in the yellow highlighted column. The pie chart is more for me and just a visual.
Any help you can provide would be much appreciated.
Thank you,
Phil
Bookmarks