Hello
I was hoping someone far more capable than I could help me with an
Excel 2002 problem.

I am using an IF formula:
=IF('EXPECTED WORKLOAD'!$G$51=$A8,'EXPECTED WORKLOAD'!G$163,"")
to check for a certain number (a week number) on another worksheet
(EXPECTED WORKLOAD), if it is found, a value (the number of hours
spent on a task) is placed into the cell. The next row does the same
thing:
=IF('EXPECTED WORKLOAD'!$G$51=$A9,'EXPECTED WORKLOAD'!G$163,"") but is
looking for the next weeks number. The aim is to have a history of
data that can be used to analyse performance (at the moment this list
is used in a pivot chart).
The problem I am having is that whenever the week changes in the
EXPECTED WORKLOAD sheet the original entry disappears i.e. is replaced
with the "" part of the IF statement.
I have got round this by manually over-typing the formula with the
value but I'm sure there must be a better way of recording the
history.

(I hope this makes some sort of sense to you)

Any help you can give would be greatly appreciated and thanks in
advance.

gklr