[Task] Dependencies [In a Schedule]

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!

Thanks for taking a swing at it, really appreciate your time.

I had a feeling that what I was asking for wouldn't be a simple solution, I'll play around with your sheet and try to integrate something similar into mine.

That being said, if anyone had any other design ideas to get around this, it'd be greatly appreciated.

Hi 6StringJazzer & wvtn,

Good morning

As per Mr.String created table I have incorporated some of tasks with links and lag days to meet the earliest possible start date with connecting cell formulas; and this is working for 'n' of tasks and predecessors (if provided with links & lags in each predecessors), but here I have issue is if I defined by must finish to finish with lag days in task A20 then the earliest possible end date is adjusted with formulas but my earliest possible start date is not getting adjusted in line with earliest possible end date (as it was defined in links).


Also If I have given the actual start date then the desired end date is formulated automatically, but if in case the reverse I also look after if I put actual start date & actual end date (as per actual events) then the following task links should adjust automatically in line with actuals as tracking of works to the present scenarios; please advise further to move on this.

Thanking you

Regards,
JD.Nethaji