PDA

View Full Version : Audit Log - track changes to all cells in a workbook



dek
04-19-2015, 05:28 AM
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.