nehamittal03
New Member
- Joined
- Sep 7, 2016
- Messages
- 1
Hi,
I have this spreadsheet which has tasks with one or more dependencies. These tasks can begin only after their dependencies are complete i.e. start date of task > max of end dates of its dependencies.
I need to validate the start date of all the tasks which have dependencies based on above logic. Is it possible to write a macro for this? Thanks in advance for help.
The spreadsheet I'm talking about looks something like this:
<tbody>
</tbody><colgroup><col><col><col><col><col></colgroup>
I have this spreadsheet which has tasks with one or more dependencies. These tasks can begin only after their dependencies are complete i.e. start date of task > max of end dates of its dependencies.
I need to validate the start date of all the tasks which have dependencies based on above logic. Is it possible to write a macro for this? Thanks in advance for help.
The spreadsheet I'm talking about looks something like this:
Task Ref | Task | Start Date | Target End Date | Dependencies |
A.1 | Obtain internal approvals | 10/1/2015 | 8/1/2016 | |
A.2 | Obtain approval from the Committee | 11/1/2015 | 12/9/2015 | |
A.3 | Determine whether something is established | 1/1/2016 | 6/30/2016 | |
A.4 | Update database | 10/1/2016 | 12/1/2016 | Obtain internal approvals Obtain approval from the Committee Determine whether something is established |
A.5 | Inform Some one | 10/1/2016 | 10/1/2016 | Update database |
<tbody>
</tbody><colgroup><col><col><col><col><col></colgroup>