Record the previous value of cell to another Worksheet

[Lexian]

Hi,

Is this possible? if I change something on my active sheet, the previous value of the cell will transfer to another worksheet, like a history of the changes made in my active worksheet.

I know there is a built in function in excel (track changes) but If I do this, my other macros won't work..

I want to create a new worksheet, where all the previous values will store. is this possible?

Thank you in advance,

[kev_]

I know there is a built in function in excel (track changes) but If I do this, my other macros won't work..

Write your own macro to track the changes your are interested in

VBA below tracks movements in cell A1 and time stamps values and logs in tracking sheet "TrackA1"
- Test in attached workbook by amending the values in A1 in first sheet
- the VBA is in the first sheet's module

Please Login or Register  to view this content.