I work in an environment where Spreadsheets are a Collaborative effort, and will often go through dozens of iterations by several different people along the way.
I recently found the "track changes" ability which has been great for working out what amendments people have made to what I have sent out.
What I am looking to do, is a have a worksheet which is a "Version History", which is a single repository of the history of what has changed along the way. Is there a way of programmatically retrieving the "Track Changes" details, and storing them in that worksheet? I guess, as a second step it would be appropriate to "Take over" approve changes process, to determine which changes get documented in that sheet.
Has anyone done anything like this?
I recently found the "track changes" ability which has been great for working out what amendments people have made to what I have sent out.
What I am looking to do, is a have a worksheet which is a "Version History", which is a single repository of the history of what has changed along the way. Is there a way of programmatically retrieving the "Track Changes" details, and storing them in that worksheet? I guess, as a second step it would be appropriate to "Take over" approve changes process, to determine which changes get documented in that sheet.
Has anyone done anything like this?