+ Reply to Thread
Results 1 to 2 of 2

Automatically updating budget allocation? See example attached

  1. #1
    Registered User
    Join Date
    08-30-2007
    Location
    Dublin, Ireland
    Posts
    18

    Automatically updating budget allocation? See example attached

    Hi all,

    Hopefully someone can assist, i spent too much time messing about with this today

    It should be simple, i have a spreadsheet that i want to circulate to several managers to track employee expenses, each manager has an annual budget.

    So in Jan each month has the annual budget divided by 12.

    Once jan expenses are in the over or under spend for that month then affects the monthly budget for feb and forward.

    The wrinkle is that i have two months in the middle of the year in which special events are on that will require travel so the budgets in these months need to be higher, thus lowering the other months.

    What i want is that the monthly budget in say april and may is the same as august and september (the months either side of the months with the special extra budget)

    however the way my formula works isnt right for this.

    Because its a sheet that will be sent out i want the manager to be able to put values in certain months to see how it will affect their budget for the rest of the year.

    i have attached an example,

    thank you in advance.
    Attached Files Attached Files

  2. #2
    Registered User
    Join Date
    08-30-2007
    Location
    Dublin, Ireland
    Posts
    18

    Re: Automatically updating budget allocation? See example attached

    Any help I could get on this would be much appreciated

+ Reply to Thread

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