Forum Discussion
Record the cell changes
NaradaJay95 I was responding as the former Director of the HR/Payroll database for a major US corporation. Patrick2788 gave you a feature of Excel that tracks changes to a spreadsheet. If that's what you're seeking, that's fine by me.
My reading of your question, though, comes from my own background: I was assuming you were really seeking the most effective ways to keep what would amount to "Employee History," specifically in connection with "retention status".....but quite possible Employee History as it applies to all kinds of status changes, from hires to promotions, to salary changes, through to termination or retirement. That's also why I asked that you post a copy (without real names) of what you have now in place as an employee database. There's no reason, I assume, for us to design something "from scratch."
mathetes .
| Emp ID | Employee Name | Current Risk Status - Retention |
| 1 | Employee A | No Known Risk |
| 2 | Employee B | Low Risk - 1 - 2 year |
| 3 | Employee C | Medium Risk - Within 1 year |
| 4 | Employee D | High Risk - Immediate |
Current Risk Status changes time to time based on the latest update of the risk. For example Employee A can be in "No Known Risk" in the month of Jan and then changed to "Low Risk - 1 - 2 year" in the month of Feb. So I need to track those changed monthly in a table like below.
| Emp ID | Employee Name | Jan-23 | Feb-23 |
| 1 | Employee A | No Known Risk | Low Risk - 1 - 2 year |