Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Postman
I have got another problem that i am hoping you could help out. I hope
i can phrase it as detail as possible. I have a master worksheet that hold the list of inventory(bill of material) and the corresponding quantity that i have on hand like say we name it (MasterInventory). The value in the MasterInventory is dynamic, quantity will be deducted went a certain component is used in the production of a product and will increase when supply come in. The data of the supply come in the form of another excel worksheet. It is broken down into dates that they will be deliver. Example is as follow: MasterInventory (Before) model part number/description Quantity 12/1 13/1 15/1 LP120 12-1234-12 12 12 12 12 LP120 13-1234-14 05 05 05 05 M1 15-1234-12 10 10 10 10 009C 14-1234-15 01 01 01 01 SupplyData Mon Tue Wed Thu part number/description 12/1 13/1 15/1 17/1 12-1234-12 02 02 03 04 13-1234-14 01 00 03 01 14-1234-15 00 01 03 00 What i am trying to do is something like a postman. Sorry if i use inappropriate terms. The SupplyData are like the letters he has to deliver and the MasterInventory is the letter box with different pigion hole that he can slot the letter accordingly. Meaning the quantity in the MasterInventory will find matching part number from the SupplyData and add up its current quantity(MasterInventory) with the new quantity that is due to deliver(SupplyData) according to the date. MasterInventory (After) model part number/description Quantity 12/1 13/1 15/1 LP120 12-1234-12 12 14 16 19 LP120 13-1234-14 05 06 06 09 M1 15-1234-12 10 10 10 10 009C 14-1234-15 01 01 02 02 The reason that i am trying to do this to relief the user from data entry as this will help to reduce human error. Thanks if you could help. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Postman
See one response to your earlier post (better?) titled as:
Updating inventory quantity -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|