Re- Assign Data

 Hi,

We have a requirement to re-assign data in the instance where someone joins/leaves the company and to support adhoc movement of record ownership. For example Sales Rep A leaves the company, I now want to identify all records owned by Sales Rep A and change the ownership so that Sales Rep B has these records. The problem here is the vast number of entities that they require updating.

I appreciate this is pretty impossible to do without exporting data and re-importing data but was wondering whether someone else had a similar requirement and whether they had any suggestions. Is there any work arounds/alternate suggestions would be appreciated.