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!
Bookmarks