What is the best way to handle changes on assigned person?

Suppose one of my coworkers left the company and there is this new person coming in to fill the same position, same responsibility, etc.

I want to make sure all of the shared sheets (not just the owned ones) and also all of the assigned cells transferred from the person who left to the new person.

What is the best way for me to do that? I know transfer ownership on user management, but it can only give every item that was owned by the old person.

On another note, how can I do that if I use the auto-provision for the new user via Active Directory?

Thanks for the help!

Answers