One way is easy, it can be done with Formula
But reverse where either worksheet can change will require VBA
Do you have such a worksheet setup now?
Do you require one setup ?
Could you explain why you need it setup as such ?
i don't know why he need it. but this is a todays task for me. pleasePlease find out why you need such a setup?