close

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

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

www.mcgimpsey.com/excel/timestamp.html

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

Pendelfin wrote:
gt;
gt; Is it possible to include an audit trail in a spreadsheet.
gt;
gt; I have a spreadsheet set up that many users will be able to update, and I
gt; would like to see who/when it is amended.
gt;
gt; Many Thanks

--

Dave Peterson

全站熱搜
創作者介紹
創作者 software 的頭像
software

software

software 發表在 痞客邦 留言(0) 人氣()