Tracking the "Track Changes"

MisterQ

New Member
Joined
Jun 12, 2014
Messages
7
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?
 

Some videos you may like

Excel Facts

How to fill five years of quarters?
Type 1Q-2023 in a cell. Grab the fill handle and drag down or right. After 4Q-2023, Excel will jump to 1Q-2024. Dash can be any character.

Watch MrExcel Video

Forum statistics

Threads
1,108,960
Messages
5,525,914
Members
409,671
Latest member
nasseralateek

This Week's Hot Topics

Top