I am new to excel, and am creating a budget workbook. I have sheets for each month, with entries for different expenses. These sheets all contain various formulas to automatically calculate total $ spent on each item, compared to income.
What I am trying to learn is how to create a page where I can select from drop down menus the month, category (debt, utilities, expenses, etc.), type (credit card, groceries, etc.), and then type the amount spent, and that value is automatically added to the corresponding sheet and cell. For example, if you purchased a red bull, you can selct the October, Expenses, Junk food, from the drop downs, and then type 2.14. Then this amount is automatically added to the October sheet, under the expenses category, and "junk food" type, where it originally showed $10.00, and now shows $12.14 after the entry.
I have been searching the internet for this solution, and have seen a lot of information on creating a data table and data validation, but have not found anything clear on my desired outcome. Any help or direction to tutorials will be greatly appreciated.
Thank you so much.
