Help with VBA code

[mrbcodc87]

I have a database spreadsheet that gets added to via another sheet in the workbook.
once the data has been added to the database it may need editing but i need a log of who edited it and why
I need a code the does the following.

if any cell in each row is edited in the database it adds a 'yes' in column 'K' and username and time stamp in column 'J' of the same row.
then copy this entire row and insert the text into 2 database log file that are already created 'c:\Scada Logs\Data Log.txt' & 'o:\Scada Logs\Data Log.txt'
save and close the text file

Thanks in advance for you help

 

[Logit]

Track changes within a workbook without sharing the workbook