Hi all,
This is going to be a big ask so thanks for any help anyone can give
What I need is a macro which will show me how many hours are loaded to a work center and if the work center is overloaded on hours when the macro is run
So I have sheets "home" "production orders" and "routings"
The home sheet is blank and is where I want the report
The production orders has various data but the data that I need to use is the material number the qty and the start and end date
The routings sheet has the material number the operation number the work center it goes on and how many hours the parts take to machine each
What I somehow need to do is look on the production orders sheet down a range pick up each material number, qty and start date then reference that material number to the material number on the routings sheet and work out based on the work center how many hours are loaded to that machine and how many weeks it will span over.
The report I need to see at the end should have all the work centers displayed and the hours loaded to that machine each week, so work center 1 might have 40 hours loaded in week 50 and 20 hours loaded in week 51 and so on... , I dont mind if this is in chart form or not, the capacity for each machine is 37 hrs per week
I have attached a workbook for to look at
Thanks again
Bookmarks