mrbcodc87
New Member
- Joined
- May 19, 2020
- Messages
- 6
- Office Version
- 365
- Platform
- Windows
- MacOS
- Mobile
- Web
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
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