Implement Audit Trail Feature to Track Changes

Apr 15, 2019 | Excel, VBA

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,...

Find the Last Row and Last Column in Excel using VBA

Apr 9, 2019 | Excel, VBA

When writing VBA, one of the most important things is to figure out the table dimension, like figuring out the last row and last column of a table. Using VBA, we can easily write just few lines of code to find the last row and last column index....

Create a Vlooup Function To Extract All The Associated Values

Apr 5, 2019 | Excel, VBA

One of the limitations with Excel VLOOKUP function is that, when you have multiple matched values, the function will return the first matched record. In this tutorial, I will show you how to create a Used Defined Function (UDF) to perform VLOOKUP that can extract...