How to Log Audit trail of a particular cell of a Worksheet

[VenkateshV]

Hi Folks,

I'm relatively beginner and new to this forum. and appreciate if could help me to get the coding idea How to Log Audit trail of a particular cell or cells of a Worksheet

---

Say I have a workbook where i have worksheet "Sheet1" where the records are displayed as indicated below.

ID	Val1	val2	val3
1	2	Apple	2 Apple
2	5	Orange	5 Orange

<tbody>
</tbody>

Where fields Va1, and val3 is text and val3 is a formula based cell displays the final result. (i.e. concatenates val1 & Val2 and displays as a final string value)

---

Audit Log Population part

Now i start editing the val1 & val2 fields in a later date and wanted to know the full audit log trail of cells val1 to val3, with details like

1) what is old value , 2) what is new value and 3) Time of change Date & Time informations

and get the audit log populated in another sheet "Logs" within this same workbook.

On the "Logs" Worksheet which basically resembles same as "Sheet1", i want all the audit trail logs of the individual cell changes get populated on the same cells appended one after the other and should look like below.

say after i have performed 2 changes on my val1 & val2

ID	Val1	Va2	val3
1	old, new, Time 2, 3, 08-Dec-17 09:09:02 3, 5, 09-Dec-17 10:13:11	old, new, Time Apple, grape, 08-Dec-17 09:10:02 grape, cherry, 09-Dec-17 10:13:15	old, new, Time 2 Apple, 3 grape, 08-Dec-17 09:10:02 3 grape, 5 cherry, 09-Dec-17 10:13:15
2	old, new, Time 5, 4, 08-Dec-17 09:09:01 4, 2, 09-Dec-17 10:13:13	old, new, Time Orange, Fir, 08-Dec-17 09:10:02 Fir, grape, 09-Dec-17 10:13:18	old, new, Time 5 Orange, 4 Fir, 08-Dec-17 09:10:02 4 Fir, 2 Grape, 09-Dec-17 10:13:18

<tbody>
</tbody>

Kindly help me a simple and efficient VBA coding by which i can achieve above.

Many thanks in advance for your support.

Regards
Venkat