Working Backwards with Production and Shipments
Eliminate Pivot Table Annoyances
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 3 of 3

Thread: Working Backwards with Production and Shipments

  1. #1
    New Member
    Join Date
    Jan 2002
    Location
    New Zealand
    Posts
    11
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

     
    Hi all,

    I was just wondering if anyone could help me with this problem,

    I am trying to work out how to get a column in my spreadsheet that will work out (backwards) which shipment we are producing for at the corresponding date

    I have the sheet set out as follows:

    A B C D E F
    Date Prod InStock Shipped Ship ForShip


    As there is no regular interval between shipments, I need something that can start at the bottom and work its way up by looking at D (shipped) and then subtract each days production from this until it reaches zero,all the time putting the ship name in F (ForShip). Then once it reaches zero, I need it to go back down to one cell above the previous D cell used and repeat, continuing the subtraction from the date where the previous calculation reached zero!

    Way to hard for my little brain.

    I am not very good at code but will try anything! (thats if anyone even understood what the heck I am on about!)

    Thanks in advance!


  2. #2
    Board Regular
    Join Date
    Jun 2004
    Location
    Philadelphia, PA
    Posts
    547
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Working Backwards with Production and Shipments

    Did you figure this one out?

  3. #3
    MrExcel MVP fairwinds's Avatar
    Join Date
    May 2003
    Posts
    8,637
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Working Backwards with Production and Shipments

      
    Hi,

    Why did you wake this oldie up?

    Same problem?

    ******** ******************** ************************************************************************>
    Microsoft Excel - Book1___Running: xl2002 XP : OS = Windows 98
    File Edit View Insert Options Tools Data Window Help About
    =

    A
    B
    C
    D
    E
    F
    G
    1
    DateProdInStockShippedShipShippedForShip
    2
    2004-10-10100100 0Sea Hawk
    3
    2004-10-11100200 0Sea Hawk
    4
    2004-10-12100300 0Sea Hawk
    5
    2004-10-13100400 0Sea Cloud
    6
    2004-10-14100500 0Sea Cloud
    7
    2004-10-15100600 0Sea Cloud
    8
    2004-10-16100400300Sea Hawk300Sea Cloud
    9
    2004-10-17100500 300Sea Cloud
    10
    2004-10-18100600 300Titanic
    11
    2004-10-19100700 300Titanic
    12
    2004-10-20100300500Sea Cloud800Titanic
    13
    2004-10-21100400 800Titanic
    14
    2004-10-22100500 800QE2
    15
    2004-10-23100200400Titanic1200QE2
    16
    2004-10-24100300 1200QE2
    17
    2004-10-25100400 1200QE2
    18
    2004-10-26100500 1200QE2
    19
    2004-10-271000600QE21800QE2
    Sheet1

    [HtmlMaker light Ver1.11] To see the formula in the cells just click on the cells hyperlink or click the Name box
    PLEASE DO NOT QUOTE THIS TABLE IMAGE ON SAME PAGE! OTHEWISE, ERROR OF JavaScript OCCUR.
    "Fair Winds and Following Seas"

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

 

 
DMCA.com