How To Shift times in schedule

[thunder_anger]

this is a sample data of my sheet
Excel 2010

	A	B	C	D	E	F	G	H	I
1
2	PlanStartPoint	29/06/2015
3
4	Task	Priority	StartDate	Duration	PlannedEndDate	Progress	ActualEndDate	ActualDuration	Notes
5	Task 1	100	29/06/2015	8	07/07/2015	37.5%
6	Task 2	100	07/07/2015	6	13/07/2015
7	Task 3	100	13/07/2015	3	16/07/2015

<colgroup><col style="width: 25pxpx"><col><col><col><col><col><col><col><col><col></colgroup><thead>
</thead><tbody>
</tbody>

Sheet1​

Worksheet Formulas Cell Formula E5 =IF(C5="","",C5+D5) F5 =(TODAY()-C5)/(E5-C5) E6 =IF(C6="","",C6+D6) F6 =IF(G5="","",(TODAY()-C6)/(E6-C6)) E7 =IF(C7="","",C7+D7) F7 =IF(G6="","",(TODAY()-C7)/(E7-C7)) H5 =IF(G5="","",G5-C5) C5 =B2 C6 =IF(G5="",E5,G5) C7 =IF(G6="",E6,G6) <thead> </thead><tbody> </tbody>

<tbody>
</tbody>

If i want to record another task that have a priority of 150 is there a way to make the tasks to reorder and shift times for me - the first task already began in 29/6/2015 and has 37.5% progress ( i want to pause not delete) so the "PlannedEndDate" will change to add the duration of the task with 150 priority - i wan the new task with 150 priority to come before that and takes the date of the record and shift the times of the schedule I hope that i am clear enough and thank you in advance

<tbody>
</tbody>

 

[thunder_anger]

no one !!!