Results 1 to 1 of 1

Fomula to list order numbers and relevent stock movements

Threaded View

Porterrob Fomula to list order numbers... 10-25-2010, 12:07 PM
  1. #1
    Registered User
    Join Date
    10-25-2010
    Location
    London, England
    MS-Off Ver
    Excel 2002
    Posts
    2

    Exclamation Fomula to list order numbers and relevent stock movements

    Hi

    I've set out a spreadsheet to help with stock control at work and need help on one final formula that I cannot solve myself.

    Basically I have one worksheet called stock and another worksheet called stock out, now I've linked them both up for the total stock movements out over the month. However I need to get it so that individual PO movements from the stock out show up on the relevant PO on stock. For Example

    Stock Worksheet
    Part 1 12pcs in total

    Stock out
    Part 1 3pcs from 82012 7pcs from 86483

    As you can see the total stock is easily linked in, however I need to know how much has come from each PO to create that total, so that, for example,on the stock worksheet it would show that 3pcs of part 1 came from PO 82012 and 7 from 86483 and so on.

    Any help would be greatly appreciated.

    Thanks
    Last edited by Porterrob; 10-26-2010 at 04:46 AM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Tags for this Thread

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