I want to tet MS Project adjust previous dependent tasks' schedule based on last task's due date. I'll try to tell my requirement via image below:
last row is a milestone (final report) and has a due date that CAN'T, MUST NOT change. So I chosed it's constraint as Finish No Later Than and entered its due date manually. I also entered its predecessor task.
I also entered 1-5 tasks' duration and predecessor tasks.
I don't care about start and finish date of the first 5 tasks. I require MS Project adjust the start-end date for these 5 tasks automatically based on due date of the last row + predecessor relations.
As you can see from image, milestone (last row) is not at the right of task 5; but it should. Milestone point is fixed and MS project should layout all other previous tasks at the left of it with proper start and end dates.
I'm using MS Project 2007.
I also tried start-to-finish relations but I created conflicts. So the image is best I could do but it's not reflecting what I need. I have hundreds of rows and relations like this, so I need to cope with this simplified scenario firstly. Googleing also didn't help me.
In my real case, I will use resources with percentage values. (I gave this info because it may effect your answer, I'm not sure)
I am not good at MS Project so this was my best.
Can you please tell me the correct way to achieve this?