pubcrawler
New Member
I wonder if someone can help with some scheduling help.
I have a list of tasks that have different durations.
I have a number of facilities which I would like to distribute the tasks across
When the task is complete (task end date) the next task in the list will go to that facility.
I need to automate this as i have a task list which is changing daily and is 160 tasks long. I need to communicate to a customer expected start date of x task.
i am struggling to generate a new start date and identify a facility for a task in the list where the date clashes with a facility which is already executing a task.
I have tried a number of formula, min(), Vlookup() if(). I did think of using VBA to loop through the list of tasks assign a facility and then check dates, but i keep getting lost trying to copy similar examples and modifying the code. any help would be much appreciated.
Please find layout attached which i hope explains it a bit better
I have a list of tasks that have different durations.
I have a number of facilities which I would like to distribute the tasks across
When the task is complete (task end date) the next task in the list will go to that facility.
I need to automate this as i have a task list which is changing daily and is 160 tasks long. I need to communicate to a customer expected start date of x task.
i am struggling to generate a new start date and identify a facility for a task in the list where the date clashes with a facility which is already executing a task.
I have tried a number of formula, min(), Vlookup() if(). I did think of using VBA to loop through the list of tasks assign a facility and then check dates, but i keep getting lost trying to copy similar examples and modifying the code. any help would be much appreciated.
Please find layout attached which i hope explains it a bit better