+ Reply to Thread
Results 1 to 5 of 5

Populate budget according to start month

  1. #1
    Forum Contributor
    Join Date
    06-11-2009
    Location
    Cape Town
    MS-Off Ver
    Microsoft 365
    Posts
    858

    Populate budget according to start month

    I want to populate a sales budget based on the selection of a start month. The start month can be from January to June. Is there an excel formula that can accomplish this? I have attached a sample file.
    Thanks in advance
    Attached Files Attached Files
    Last edited by Aland2929; 08-19-2010 at 01:46 AM.

  2. #2
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    48,489

    Re: Populate budget according to start month

    Populate what with what? In the example, if the month selected is March, what value(s) need to be copied ... from where to where?

    Regards

  3. #3
    Forum Contributor
    Join Date
    06-11-2009
    Location
    Cape Town
    MS-Off Ver
    Microsoft 365
    Posts
    858

    Re: Populate budget according to start month

    If March is selected the values from B12 to Y12 will commence from cell D5 (March).
    If January is selected, the values from B12 to Y12 will commence from cell B5 (January).
    The month selection determines the month when the budget starts from. Hope I have explained it OK?
    Thank You.

  4. #4
    Forum Guru DonkeyOte's Avatar
    Join Date
    10-22-2008
    Location
    Northumberland, UK
    MS-Off Ver
    O365
    Posts
    21,531

    Re: Populate budget according to start month

    One possibility

    Please Login or Register  to view this content.

  5. #5
    Forum Contributor
    Join Date
    06-11-2009
    Location
    Cape Town
    MS-Off Ver
    Microsoft 365
    Posts
    858

    Re: Populate budget according to start month

    Thank you so much DonkeyOte. This works perfectly.

+ 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