Create Button & Input Cell to Add to Another Cell

[nguyeda]

Hello,

I tried searching the forums for answer on how to do this but I can't find one or didn't know specifcally what to search for.

I'm trying to create a biweekly budget/net worth excel sheet. It's attached as a screenshot.

So I have a spot that says "Expenses" then it shows C1 and C2. At the bottom of the sheet, I want those 2 buttons be like "sumbit" buttons and I want the cells next to be the entry.

Example, say I spend $100 today on Credit Card 1(C1). I'd open my excel sheet and enter $100 and press the button, then it'd INCREASE my C1 by $100 for that biweekly column.

Then I also have a button that says "Charge to D1" those apply to the checking accounts. I'd like those to DECREASE my checking accounts in the correct cell.

Of course, I'll have to adjust the bottons to go to the correct cell once the weeks changes (which changes the column obviously).

So help figuring that out would be great! If it's complicated, let me know how to adjust the button to move to the next column for the correct dates.

THANKS!

[davesexcel]

Sorry, but a picture of the worksheet does not help.
I understand what you want to do, but if you just send a picture, how would anybody be able to explain to you what to do?

Looking at your attachment, makes me wonder what is wrong with using a simple formula?

[nguyeda]

What simple formula? I'm not sure which one does what I'm asking. Here it is!

[davesexcel]

Try this out...
I don't have XL 2007, so you may have lost some formatting in when I converted it to XL 2003.