Avias
A number of methods for doing what you want come to mind, but not
knowing your operation and/or data layout, it's hard to give you anything
definitive.
One idea is this:
Say you have one column for order number, another column for part name, and
five columns for the days of the week. That's 7 columns. Let's say that
you color the eighth column, Column H, some color so that Column H stands
out. When you enter something in any of the five day columns, Excel does
nothing. But if you click on Column H (in the row in question) Excel will
pop up a query and ask you how many days to shift the value in that row.
When you enter a number in response, Excel will shift the value that many
days. At the same time, Excel will make a record of the shift on another
sheet, maybe including the date of the shift, and total up anything you
want.
There are other ways of having Excel "remember" the number of shifts.
But anyway you choose to go, Excel will need to know, somehow, that an entry
is an initial entry and not a shift of an already existing entry.
Post back if this interests you. Also include more detail about your
data layout. For instance, does your data really have only 5 days? HTH
Otto

"Avais" wrote in message
m...
Hi,

I run a manufacturing production sheet in Excel 2002 to plan
production.

I have approx 500 rows of orders. I have columns labelled Mon, Tue,
Wed, Thu, Fri. Each day I sit with my supervisors and try to agree
which orders we will complete and on which day. Once agreed I will
place the order £'s value along the row under a day the supervisor has
promised, eg.

Mon Tue Wed Thu Fri

Order1-Hammer £2
Order2-Wrench £5
Order3-Screw £5
etc..etc.

The problem I have is that as each day goes by, my supervisors 'delay'
their promises and I have to move their commited date forward by a
day. eg.


Mon Tue Wed Thu Fri

Order1-Hammer £2
Order2-Wrench £5
Order3-Screw £5
etc..etc.

What I need excel to do is 'COUNT' how many times the supervisor broke
his promise and I had to change the production date. In the example
above all 3 orders were changed once each.

I need excel to somehow remember the the change!

I appreciate your help in advance because I know this is going to be a
real nightmare of a job!!

Thanks,

Avais