ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Audit Trail (https://www.excelbanter.com/excel-discussion-misc-queries/66765-audit-trail.html)

Pendelfin

Audit Trail
 
Is it possible to include an audit trail in a spreadsheet.

I have a spreadsheet set up that many users will be able to update, and I
would like to see who/when it is amended.

Many Thanks

Dave Peterson

Audit Trail
 
J.E. McGimpsey shows a way to put a time stamp on the same row when something
changes:

http://www.mcgimpsey.com/excel/timestamp.html

You could use that technique to add the username to an adjacent cell, too.

Pendelfin wrote:

Is it possible to include an audit trail in a spreadsheet.

I have a spreadsheet set up that many users will be able to update, and I
would like to see who/when it is amended.

Many Thanks


--

Dave Peterson


All times are GMT +1. The time now is 10:41 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com