Production Schedule as per capacity

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,

Hi there,

The attachment is invalid for me - are you able to upload the spreadsheet or parts of it to display the issue?

Try to upload the sample workbook, make sure the file opens your end first and then follow the yellow banner at the top of this page on how to upload a file.

I have had a look through the file and tidied up some of the code that was there and made it function the way I think it should.

I am having trouble looking at the other bits listed as some of the columns the code is looking at seem to be off, maybe if you could set the file up so that one of the machines will drop to 0 when assigning the machine to the filtered data. This way i would be able to look at how to make it fit your criteria.

I have attached the file where I have made some changes to the code