Multiple dropdownlist linked to Cell

I am trying to see if Excel can do this:
I have a budget spreadsheet with items I have budgeted for with 4 columns that represent each week of a month. In another section, I have a 4 column layout that is going to be the transactions that I do during the month. (type, date, amount, and week)
I have dropdown lists in both the type (food, gas, etc.) and week (1,2,3,4). I want to be able to set them up to where if I choose Food, then week 3 in the drop downs with the amount that was spent, that that amount and any other amount that is added in the future will be added to the budget spreadsheet in that particular week.

Is it possible to do something like that? Or is this just a dream and I need to stick with manually adding them together. I hope that I have explained well enough what it is that i want to do.

I have tried Everydollar before and it does not work the way that I have my budget planned.

Many thanks if someone can help me with this!
By: Rachel Williams

Leave a Reply

Your email address will not be published. Required fields are marked *