Trying to make an expense tracker for gf

[Je56v3]

The gf has had difficulty with her expenses, so I made up a spreadsheet that is split into different budgets. It works great, calculating total income, balance, and total spent in each budget category, and how much is left in each budget. The only issue, which isn't even an issue, just a preference, I would like to make the first page of the document to be set up like a regular balance book, where you can put cost, and it'll automatically deduct from your balance, and what not. But on that, I want to create a drop down menu, that has her budget categories listed. When the category is selected, I want the price to automatically put on page two, and in the existing spreadsheet under the correct category, where my existing functions will take over and work the budgets. Can this be done, and how?

[humdingaling]

sounds like you are asking two things
1> drop down menua for categories. this can be achieved through data validation
2> button to press to trigger/push data from first sheet to back sheet

[Je56v3]

I have figured out how to do the dropdown menu, but what I cannot figure out is how to push the data to the selected category

[humdingaling]

insert a button and assign a macro to it

something along the lines of this thread?
http://www.excelforum.com/excel-prog...vba-codes.html

click a button
takes certain fields from sheet and copies in the other sheet?
some macro work needs to be done to achieve this

is this something you want to explore?
if so attach example sheet with what you have and what your expected results will be