Working Backwards with Production and Shipments
MZ Tools makes life easier for the Excel VBA coder
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
    MrExcel MVP
    Join Date
    Feb 2002
    Location
    Millbank, London, UK
    Posts
    1,790
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Gidday James,

    would you prefer code ? ie a macro ?

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

    Default

      
    Code would be great Chris

    Cheers.

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