I have been asked to complete a project at work, on excel. My excel skills are averagely dull. Let me explain the problem at hand.
I work for resin manufacturer and all the different resins that we produce, have product codes. Each resin that is drummed, is called a batch. Each batch has a timeframe that it takes to make. The guys upstairs (in operations) wants the following from me...
They want excel to automatically display the batch times of each product, by simply typing in the product code. The problem I am facing is uncertainty - I don't even know where to start. My logic tells me that I will need to create a database to store the batch times as variables, after which excel will call up the batch time upon the entry of a product code...however, this is way above my knowledge of excel and I am also not too great with access, is there perhaps an easier way?
Much appreciated,
Martin
P.S: attached is a workbook with an example of the batch times and product codes.
Bookmarks