I'm trying to create a production schedule that is 24/7 that will show an overview of what is currently running and when it'll be done. I was able to make macros (which i've never done before) so the code is horrible, I'm sure, but it works for the most part. Essentially, on the Open Orders tab, I will enter all the orders that come in. Then the production manager will look at that tab, enter the Line number ( 0 - 7) to where that order will be made at. That order will get moved to the corresponding Line tab. Once there, he will change the Status to In Progress and that order will then be moved to the Active tab which shows all the orders that are currently running. I need to fit in a chart in hourly increments but have it dynamic so the chart will progress as each day goes by, essentially never ending, really. Is this possible?
https://www.dropbox.com/s/i0ewup7nrzy1e4c/DIE SCHEDULER - Copy.xlsm?dl=0
Thank you in advance!
-Crystal
https://www.dropbox.com/s/i0ewup7nrzy1e4c/DIE SCHEDULER - Copy.xlsm?dl=0
Thank you in advance!
-Crystal
