+ Reply to Thread
Results 1 to 2 of 2

Excel 2007 : Weekly sum of deliverables resulting in a do not exceed value

  1. #1
    Registered User
    Join Date
    04-03-2012
    Location
    Astoria, NY
    MS-Off Ver
    Excel 2007
    Posts
    1

    Weekly sum of deliverables resulting in a do not exceed value

    Hello All,

    I'm new to this thread so excuse me if I'm not posting to the correct board. I'm trying to generate a formula which advises the user that their weekly count is at 25. We generate orders and deliver quantity of goods. Our capacity is maxed out at 25, so we don't want the order takers to take more than 25 goods per week. If the quantity ordered goes above 25 (taking previous orders into account as well) we want to simply highlight this so the order taker moves the quantity to another week. For example, we have bookings of the following:

    20 pieces due 3/28 and 5 due 3/29. If we receive another order for 5 pieces on 3/29, I want to highlight or generate a message once the user tries to enter it. (The data being entered is in another tab. I want the table to pull the summary from that list.

    The list in another spreadsheet looks like this:
    Qty Date
    Product X 20 3/28/2012
    Product Y 5 3/29/2012
    Product Z 5 3/29/2012

    The table in another tab, will automatically post the following:
    Product X Product Z Product Y TTL
    3/26/2012 4/1/2012 20 5 5 30
    3/9/2012 4/15/2012 0
    4/16/2012 4/22/2012 0
    4/23/2012 4/29/2012 0


    Thanks for your help!!

  2. #2
    Forum Expert dilipandey's Avatar
    Join Date
    12-05-2011
    Location
    Dubai, UAE
    MS-Off Ver
    1997 - 2016
    Posts
    8,191

    Re: Weekly sum of deliverables resulting in a do not exceed value

    Hi Mickyank,

    Welcome to the forum.

    I think rolling sum against date can help here.. suggest you to post a sample file. thanks.

    Regards,
    DILIPandey

    <click on below 'star' if this helps>
    DILIPandey
    +91 9810929744
    dilipandey@gmail.com

+ 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