Production Schedule as per capacity

[leonsoso]

Dear Experts,

Would need your valuable feedback on my subjected Query
Please refer attached Excel Sheet:-

2 Sheets: Review-Plan & Scheduling
On Sheet "Scheduling", I have many orders that need to make production schedule like ( SO, Item, Color, Teeth, etc.)

The Support which I am looking here is: -

I've already attempted to create a VBA that will filter some conditions and assign them to the appropriate machines, but I'm not sure how to code it so that when the capacity of the machine is reached, it will automatically find another machine to continue scheduling. I'm not good at VBA code.
I can't do a formular because it will get a circulation error.


I have entered some note in file's module for your further reference!

Please suggest me a Formula or Code which meets above criteria!


Thanks & Regards,