I would like to work across two worksheets and use a drop down box.

[Levi427]

First thing is first,

HELLO!! I am a new user and this is my first post!

I am using Excel 2011 on a Mac.

I am making a budget and I have several different sheets. I have a "checkbook-like" sheet where I list my purchases. In the sheet, I am listing the date, location of purchase, purchase description, cost and my new balance. I have another sheet with my monthly expenses that has a break down of all of my purchases by category and then subcategory (for example in the "Food" category, I have "groceries" and "restaurants" as a subcategory). In this sheet I also have a budgeted vs spent list. I would like to be able to fill in the checkbook sheet and have the information autofill into the budget by subcategory and have it so that every time I spend money in groceries, for example, it adds the amount spend to my previous "spent" total.

Any and all help is greatly appreciated!

(if this isn't the right place to post this thread, I apologize. Please direct me to the correct place)

Thanks!!

[alansidman]

suggest you upload a copy of your spreadsheets. This will make it easier to supply responses that are specific to your needs. Click on the Go Advanced button and follow the wizard.

[Levi427]

Here you go!