An audit trail is a record or log captures a change. For example, when you change a product price from $10 to $15, the change in the $5 difference is a trail. Audit trail is commonly used in accounting, finance, retail, and other industries. Unfortunately in Excel, there is no audit trail feature that you can just turn on and off.
In this tutorial, I will show you with help of Excel VBA and the use of Worksheet events, how you can easily implement audit trail feature to track changes in an Excel spreadsheet.
To download the file used in the tutorial –> Download Link
VBA Script
Hey, is there a way this can work for pasting multiple values into a selection of cells??
Can you give me an example?
Thanks, I was just wondering what happens when the trail sheet is full. Is there a way for the new entries to overwrite the previous ones if there is no space left?
I got a subscript out of range error with highlight on row 8. How do I fix it?
Is there a way we can also include date and time for change in audit trale