I have done many thing with excel and learned a lot of VBA with this forum's help, and I have got much help with brilliant coding VBA from this forum.
edited to add specifics of machines working hours/schedule and attached edited file also)
Usually I get half code by myself, or at least some code, and then come here for help. But this is a tough one for me: it's been a week now searching the forum and internet for some input or at least a similar code/solution but this time I have achieved nothing.
(I have never created a Gantt, not to speak of a dependency Gantt and I suspect VBA may be a immense help here rather than classic Gantt)
I have to plan production schedule in my work place. Now this is a very different animal form a previous normal planning I have been doing couple a years ago.
I only have two machines, but pace is fast. Production orders have multiplied a lot and I can not manage them anymore, nor plan without a planning of some sort.
What I have been trying to obtain is: when inserting orders in the sheet Prod ORders and durations, to fill out the hourly schedule of the two sheets of the two machines (please see attached file), based on priority order, and start date (which is initialy the date when the production order is issued)
1. IF, for example, on machine 1A, item x1 production has priority n.1, the item with priority n. 3 on the same machine 1A which in my file is item X3 production, can not initiate untill item X1 is finished.
2. Of course, even if I give a start date in the Prd orders sheet, if the machine is already busy in that date, items should populate the machine Gant in the next date and hour available
3. Based on the machines schedule when machines calendar has been filed out, I would need it to give me an end date for each item based on where the item has really found place on the machine calendar. Also, if the start date is not realistic, it should correct that one too ( in the prod order and duration sheet)
4.Machines will work from 8 am to 3 am (night)
4. Is there a VBA code, and which kind (macro? change event?) that can populate machines sheets from the Prod Order and Duration sheet as per my points above?
Any kind of input, help or suggestion would very much help.
At the moment I am walking around with pen and paper, trying to understand where and when can I start production for an item, priorities; and pruduction team and me are really in a big fog/mess at this point. Orders are starting to come in numerous and I see a big mess ahead...
Thank you in advance, any help wil be much appreciated.