I have a large excel sheet in sharepoint that is worked on by people from multiple physical locations, who can make edits to specific cells. However we regularly need to know, the values in which strings have been changed on or after a given date (as they may require follow-up). Back when we worked with non-sharepoint excel, it was an easy problem to fix by having a button that would change the value in "status" column to signify that some work was done and simultaneously append a cell in log column with the date of edit and user's initials.
But... that was in the good old days when VBA was a thing. Does anyone know of a way to do something like this in Sharepoint?
I know that in theory it's possible to check version history and compare a past version against the current one, but I was wondering if anyone knows of a way that would be somewhat practical for a common operation.
Thanks!