Results 1 to 3 of 3
  1. #1
    Join Date
    Aug 2007
    Posts
    9

    Unanswered: Daily Accounts Spreadsheet

    Hi,

    My girlfirend is currently trying to set up a spreasheet that will allow her to check her bank balance on a daily basis. She has chosen these columns; Date, Withdrawn, Paid In, Cheque No., Balance. The idea is that she will start off with a balance, then when she either has money coming into her account or when she withdraws a certain amount of money, her balance will automatically update. All the data she will enter based will be on the status of her bank account, its not linked to a bank, just a way of keeping track of personal finances at home. I think its an "IF" statement or possibly using macros, but im not great with these in Excel. Any help would be great!

    Kind Regards,

    t1ish
    Last edited by t1ish; 08-28-07 at 08:05.

  2. #2
    Join Date
    Dec 2003
    Location
    Ottawa, Canada
    Posts
    72

    Bank Account Monitoring

    Hi

    See the attached file. A simple budget application with SUMPRODUCT

    Enjoy
    Attached Files Attached Files
    A piece of data is like a brick
    If you don't build anything with it
    It is just a brick
    www.excel-examples.com

  3. #3
    Join Date
    Aug 2007
    Posts
    9
    Hi,

    Thank you for the download, it is fantastic and exactly what i need. I'll be sure to direct all my excell issues towards you in the confidence that you will be able to solve them!

    Kind regards,

    t1ish

Posting Permissions

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