-
Audit Log - track changes to all cells in a workbook
Hi
I have developed a model over 10 sheets on a modular basis (assumption sheets, calculation sheets, output/report sheets).
I would like to implement an audit log of all changes that are undertaken in the model to be captured in a separate sheet to include:
- username
- cell reference being changed
- previous value and/or formula
- new value and/or formula.
Whilst i have seen various macros that provide previous value and new value, i am ultimately seeking the macro to capture all changes (i.e including changes in forumulas)
Thanks in advance.
Tags for this Thread
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules