I have taken the liberty of producing a VBA solution based on your last file. I would however still like replies (answers) to the points in post #7 as I am sure the VBA will need adapting.
Copy the Excel VBA code
Select the workbook in which you want to store the Excel VBA code
Press Alt+F11 to open the Visual Basic Editor
Choose Insert > Module
Edit > Paste the macro into the module that appeared
Close the VBEditor
Save your workbook (Excel 2007+ select a macro-enabled file format, like *.xlsm)
[B][I]
Click "RUN" button sheet "Schedule Template VBA"
NOTE: Subroutine Production_SchedulingX use "in-core" arrays for faster processing.
Please supply a file with a more accurate representation of you "production" file.
Bookmarks