Hello everyone.
I am looking to automate what has become a very time consuming task.
My company makes a lot of different products. Most end up good and are sold.
Some end up with problems and we have a process to blend in a predetermined amount of the old bad with a new batch.
Keeping track of our production schedule compared to the inventory we have to work off is daunting.
I have attached a sample of our production schedule (Sheet 1 attached) along with a sample of our out of spec material (Sheet 2).
What I would like is the ability to paste in a copy of the production schedule to overwrite what is there and have it automatically recalculate to sheet 3.
I would also like the ability to copy and paste a new list of out of spec material over top of sheet 2 as it changes.
The way I think it could work would be to look at each product name on the schedule. Compare that name to the list of out of spec material. If an out of spec material has the same name (except whatever is in parenthesis), copy the relevant information to sheet 3.
The columns on the production schedule are (A) the date we plan to manufacture the product. (B)The day of the week that falls on. (D,F,H,K,M,O) The product name sometimes with parenthesis after it and (E,G,I,L,N,P)the amount to produce.
Please let me know if there is other information that is needed.
Thanks in advance,
Anthony
Bookmarks