I have x number of worksheets, representing x number of projects.
each project has a number of tasks ( same tasks for all projects).
For each project each task has a planned number of days per task.
The "Planned dates" can be easily calculated for each project.
A project starts when User Input "Start date", all the target dates will will calculated.
So far no issues.
The ACTUAL task date is recorded against the targeted.
I need to create a Status Work Sheet that outline Projects Status TODAY.
Each project work sheet is as follows
Task / Target / Days /Actual /
.....
Task 3 / xx-xx-xxxx/ 4 / yy-yy-yyyy /
Task 4/ xx-xx-xxx / 3
......
I need to report Task 3 (Target versus Actual ) IF IT LIES within yy-yy-yyyy + 3
For all the projects !!!!
The Summary will look something like this ( for All VALID projects) see condition above
Project 1 Task 3 xx-xx-xxxx yy-yy-yyyy
Project 3 Task 5 xx-xx-xxxx yy-yy-yyyy etc
I need your help in creating such report using VBA.
each project has a number of tasks ( same tasks for all projects).
For each project each task has a planned number of days per task.
The "Planned dates" can be easily calculated for each project.
A project starts when User Input "Start date", all the target dates will will calculated.
So far no issues.
The ACTUAL task date is recorded against the targeted.
I need to create a Status Work Sheet that outline Projects Status TODAY.
Each project work sheet is as follows
Task / Target / Days /Actual /
.....
Task 3 / xx-xx-xxxx/ 4 / yy-yy-yyyy /
Task 4/ xx-xx-xxx / 3
......
I need to report Task 3 (Target versus Actual ) IF IT LIES within yy-yy-yyyy + 3
For all the projects !!!!
The Summary will look something like this ( for All VALID projects) see condition above
Project 1 Task 3 xx-xx-xxxx yy-yy-yyyy
Project 3 Task 5 xx-xx-xxxx yy-yy-yyyy etc
I need your help in creating such report using VBA.