I've looked at this several times and am still struggling to understand how the sheet is meant to work.

I see what you are trying to do, I think, but I'm at a loss as to how you see it finally needed to work.

What are the figures in ACW Week Nos based on? How are they associated with the employees' name?

If you could explain this then it should be possible to do what you need without macros, or a least reduce them to change events.

Your problem should not be difficult, it's just a question of seeing it clearly.

Cheers