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