Results 1 to 4 of 4

Create Button & Input Cell to Add to Another Cell

Threaded View

  1. #1
    Registered User
    Join Date
    01-31-2009
    Location
    US
    MS-Off Ver
    Excel 2007
    Posts
    66

    Create Button & Input Cell to Add to Another Cell

    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!
    Attached Images Attached Images

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1