I would like to create a timeline in Excel that has a series of tasks that have predecessors and set durations. When the start date is changed the other dates change as well. A date can be changed manually and all following dates (its dependents) change in relation to the set durations.
The excel sheet will have more than one project but each follow the same timeline/process. The individual projects are on the rows and the task dates are the columns.
I have uploaded an excel workbook that has two sheets:
Sheet 1: the data with durations and dependencies
Sheet 2: the way it should look when it's done.