nehamittal03
New member
- Joined
- Sep 7, 2016
- Messages
- 1
- Reaction score
- 0
- Points
- 0
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:
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 |