Hello all,

Wondered if anyone could help me please.

Basically, at my place of work we work to annualised hours.

Currently, we add up the hours on that weeks rota and tally them up for the year to see how many each employee owes.

For example, on the rota if employee x works 20 hours in one week, that data would be extracted to another work-sheet.

This data is then deleted from the rota, and new hours for the following week are added in (say this works out to 15).

How do I ensure excel remembers the 20 from the first week when the data used to calculate that initially have been deleted for new data for a new week.

Many thanks!