+ Reply to Thread
Results 1 to 4 of 4

Budget Workbook headaches

  1. #1
    Registered User
    Join Date
    07-21-2015
    Location
    Sydney, Australia
    MS-Off Ver
    Excel 2010
    Posts
    40

    Budget Workbook headaches

    Hi all,
    I know we all love to budget! I've been designing a workbook for the family budget but I can't get it to do what I want. I have attached an example.
    What I want it for the transactions listed in the "Transaction Record" worksheet to automatically populate into the correct Expenses row of the "Budget" worksheet. To make this just that little bit harder I would like to have multiple entries for one category in the "Transaction Record" sheet and have them be added to the existing Expenses already in the "Budget"

    I hope that makes sense, especially with the attached workbook for reference. If there is any part which is unclear I'll try to clear it up.

    Thanks in advance.
    Attached Files Attached Files

  2. #2
    Registered User
    Join Date
    07-17-2015
    Location
    Scotland
    MS-Off Ver
    97
    Posts
    28

    Re: Budget Workbook headaches

    Example Budget.xlsx

    Hi,

    Is that what you were after?

    Jenn

  3. #3
    Registered User
    Join Date
    03-12-2014
    Location
    Central Texas
    MS-Off Ver
    Excel 2010
    Posts
    55

    Re: Budget Workbook headaches

    Place this code in the top space of the column to have the Expenses total, and drag-down.
    Please Login or Register  to view this content.
    This is provided that your layout is the same as your example.
    Oh! I get it. I need rep--->҉

  4. #4
    Registered User
    Join Date
    07-21-2015
    Location
    Sydney, Australia
    MS-Off Ver
    Excel 2010
    Posts
    40

    Re: Budget Workbook headaches

    Thanks! I knew it would be easy once I knew what formula to use.

    Marked as solved.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Budget workbook, multiplying hours to make $
    By janet_omc in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 03-15-2013, 05:47 PM
  2. budget formula. 2 different formulas for yearly budget SUMIF?
    By italianstallion in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 03-04-2013, 05:20 AM
  3. New to these headaches.
    By Sparty52 in forum Hello..Introduce yourself
    Replies: 1
    Last Post: 01-11-2013, 03:45 PM
  4. Replies: 1
    Last Post: 11-02-2010, 04:04 PM
  5. Pulling weekly budget data into monthly budget
    By MarkRabbit in forum Excel General
    Replies: 4
    Last Post: 10-19-2008, 04:28 PM
  6. income and budget workbook
    By dtevol in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 04-04-2008, 01:15 PM
  7. Formula Headaches.
    By Cyberpawz in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 11-11-2007, 09:11 PM
  8. Easy for you.... headaches for me !!!
    By saltymut in forum Excel General
    Replies: 7
    Last Post: 01-20-2007, 03:20 PM

Tags for this Thread

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