Improving Excel with Python (Day 5 of 5)
My starter scripts in January 2021:
Track changes in Excel
My most hated feature of Excel is tracked changes.
Tracked changes in Excel are presented in a separate tab, away from the data that has been changed, presenting challenges to any user who needs to trace back over the changes that have been made.
I explored creating a more intuitive display of tracked changes using cell comments to show a full audit trail of the changes made.
Here’s a snippet that logs the changes made in Excel by updating the cell comments with a time and the cell’s previous value.
This brings my short exploration into solving Excel problems with Python to a close.
But the possibilities are endless, so if you have ideas, please get in touch:)
Have a look at the full code I used, here: