We are developing a schedule to control what specific work is performed in our warehouse. We want to give the worker a sheet of paper (report) with a list of specific boxes numbers for him/her to pull for shipment or movement to a different physical location within the warehouse. Shipment or movement is dependent upon how old the material is. The goal is to ship out the oldest material first.
Eacher box has a unique identifier in the ERP, which also matches the identifier on the packaging of each box. We hold inventory of each part and we may have 50 boxes of any given part, with probable different ages within the system. We are able to generate a listing of specific boxes manually based on demand and age, however we need to automate this. What would be a good method of doing this and what would the code be? I'm assuming we will need to use VBA, however I could be wrong. I have decent Excel skills, however programming is above me currently. We are using Excel 2010.
Any help would be greatly appreciated.
Attached is a very simplified example. One spreadsheet reflects our quantity on hand and the 2nd reflects customer orders.
Bookmarks