Thread: Offset copy

Have a look at the attached example.

I have a row of tasks automatically populated into column B. These are scheduled tasks at certain days looking ahead.

In Cell C25 I want to Enter the Task due which means the task will be done earlier than schedule.

Is there any way the tasks in Column B can realign themselves.

All help much appreciated

Martin