Results 1 to 9 of 9

Link budget category with actual budgeted value

Threaded View

Jelapprand Link budget category with... 10-15-2020, 10:12 AM
vba_php Re: Link budget category with... 10-16-2020, 11:13 AM
Jelapprand Re: Link budget category with... 10-16-2020, 11:28 AM
vba_php Re: Link budget category with... 10-16-2020, 01:09 PM
Jelapprand Re: Link budget category with... 10-16-2020, 01:21 PM
vba_php Re: Link budget category with... 10-16-2020, 06:00 PM
vba_php Re: Link budget category with... 10-16-2020, 06:02 PM
Jelapprand Re: Link budget category with... 10-16-2020, 11:27 PM
vba_php Re: Link budget category with... 10-17-2020, 12:59 AM
  1. #1
    Registered User
    Join Date
    10-15-2020
    Location
    Lansing, Michigan, U.S.A.
    MS-Off Ver
    Office 365
    Posts
    5

    Link budget category with actual budgeted value

    Hello,

    My wife and I are tweaking our newly made budget sheet. We mark down expenses, and those quantities are totaled and placed into a given category of expense. Next to that category, I added a column for budgeted amounts. Next to that column is another, where I have each cell calculate the difference between what we've budgeted for a given category and what we've actually spent. Values (negative or positive) in that "difference" column carry over to the next month's budgeted column.

    I have attached an image of a blank month to give you an idea of what it looks like.

    As the months and years progress, these expense categories are likely to change. Instead of having to change and re-order categories month by month, we have all categories in that column remit to the "Year" summary sheet (highlighted in the image), where we edit categories for the whole workbook. What I just realized, however, is that if I edit the categories listed in the summary sheet, the budgeted values and differences will no longer line up with the expense categories in the month sheets.

    Is it possible for me to force a row in the "budgeted" and "difference" columns to stay next to a given text from the "category" column, even when the latter moves up or down because a new category was added?

    Many thanks!
    Attached Images Attached Images
    Attached Files Attached Files
    Last edited by Jelapprand; 10-15-2020 at 10:41 AM. Reason: Adding an actual copy (blank, no personal information) of the spreadsheet I'm asking for help with

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 2
    Last Post: 03-15-2017, 03:14 AM
  2. Actual Vs. Budgeted Financial
    By Neilesh Kumar in forum Excel General
    Replies: 1
    Last Post: 06-20-2016, 07:15 AM
  3. Weekly Budgeted Vs. Actual Cash Flow
    By Neilesh Kumar in forum Excel General
    Replies: 3
    Last Post: 06-13-2016, 07:26 AM
  4. Replies: 1
    Last Post: 03-24-2014, 12:37 PM
  5. [SOLVED] Need % of Actual over Budgeted. Budgeted 0 actual 160
    By ChristyB in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 02-16-2006, 02:10 PM
  6. [SOLVED] Budget vs. Actual
    By Stanley in forum Excel General
    Replies: 0
    Last Post: 12-16-2005, 05:10 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