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.