Week 10 11 12 13 Forecast Balance Worst
case
Order book 75,261 91,423 83,455
70,585
Sales achieved 2,326 9,649 8,655 33,500 12,870

The Sales and order book has sheets for each month data and monthly sheet
has columns for weekly information.

The order book and sales achieved is updated at end of each week. Sales
forecast is entered at beginning of month. Balance is forecast less
achievement.

The worst case order book is week end order position less Balance . At the
end of 1st week c2, d2, e2 will be blank; at end of week 2 d2 & e2 will be
blank ....

As and when we enter each weeks information I am required to alter the
formula for Worst case order book from b2 to c2 to d 2 and so on. Is there
any way I can automate it -

Week end order position is updated manually as it is net of cancellations etc.


Thanks in advance