Spotted another problem that has only just started to occur.

When you enter a line in the green cells in row 7 on the INPUT sheet, if you enter a long sickness range for someone e.g. a few months, so it makes them use both full and half occ. You will see the 4 lines (2 code & 2 description lines) produced in the output section on the input sheet. This works fine and has always worked fine.

However, all of a sudden now when you click next to get it to copy this data to the OUT PUT sheet something strange is happening and it doubles the line up for example...

If someone had 50 days full allowance and 50 days half allowance

You key a line and they are off for 70 working days

So the line for full should say 50 and the line for half should say 20

This is the going on to the pend section too quickly and so it recalculates and submits a new line which then does an additional 30 on half pay and 40 on nil pay.

It needs to only copy over what is there and not update during the process

I would really appreciate any help I can get, I am training HR at the moment and the tool has stopped working.

Nightmare!