Hey Everyone,

I've been tasked with creating a schedule from a list of tasks that can also link dependencies.

Here's an example:

Column A - Task | Column B - Start | Column C - Duration | Column D - End | Column E - Dependencies

Task1 | Jan 1 | 4 | Jan 5 | *
....

The Task list is about 50 cells long. In Column E - Dependencies, I would like to be able to produce a dropdown list of all the other tasks. Checking off one or more dependency tasks should ultimately force the Start date to begin later than the latest selected task dependency. (IE. For Task 5, I selected Task 2, Task 6, and Task 10 as the dependencies, if the start date for Task 5 is less than Task 2,6, or 10, it should indicate that there is an error.)

Apologies if this is not very clear, I've been suddenly tasked with coming up with the spreadsheet and have been coming up short on how I would be able to capture the dependencies. I'm open to use Macros/VBA but am quite new at it so will need a little help in understanding the code/macro.

Thanks in advance!