VBA code to insert text into a row when new data is entered + refresh a chart

[mhopke]

The title is HORRIBLE I'm sorry. The problem is much easier than the title sounds. (I think.)

Anyway, I have a spreadsheet I'm using for a budget. For example 11/14/13 $-16.00 Dinner. Very simple.

I also have a list of each category using =sumif statements. It basically tallies all money spent in each category.

A pie chart is pointed at these "bins" or tallied categories.

I don't mind updating the pie chart data range, or moving the autofill over when I add a new category, however I'd like to give this spreadsheet to a girlfriend. (Who doesn't know anything about excel, nor cares to learn)

What I'd like to do, is add a macro button. Something that says REFRESH. So anytime a new entry is made, and a new category is generated, it will add it to the list of "bins", and also update the pie chart to incorporate the new range of data.

Also, if I'm ignorant to an easier method please, please tell me. I'm always trying to learn new things and I have a tendency to jerry-rig my spreadsheets (as you can see by my conditional formatting if you download the xlsx).

I couldn't find the option to attach the spreadsheet locally to the forum, but I made a dropbox link (I think) that contains the spreadsheet.

https://www.dropbox.com/s/r4c3ij9g2xn906v/Money.xlsx

I appreciate all the help I can get! You guys have been a great source of information for me for a long time. Now I have the chance to write it out and tell you all thanks!

Matt

 

[AlphaFrog]

There a several ready-made Personal Expense templates available with a variety of bells and whistles built-in. Do a web search for something like Excel Personal expense template

Here's a couple you may find interesting.
7 Personal Expense Trackers using Excel

 

[mhopke]

Excellent thank you for the resource! I might steal some content from one of these!