I'm looking for a most likely vba solution in order to track changes made within a defined range of cells.
At sheet1 In the range A1:Z100 I want to track changes made.
At sheet2 I want to track the changes in the following way:
date author # cel old value new value
If user NIK does change the value ABB in A15 to BBB and the value in cell B17 from xxx to yyy etc. this should be listed in shee2 respectively:
01-Sept-11, NIK, A15, ABB BBB
01-Sept-11, NIK, B17, xxx, yyy
thank you in advance for help, advice and solution.