Tracking workbook changes on new sheet using a macro help

Hi,

I've been using a code that I found to create a record of changes produced in a workbook using a new 'tracker' sheet within the workbook. The code works well, the headers of the tracker are like this:

cell Changed | Old Value | New Value | Old Formula | New Formula | Time of Change| Date of Change | User


My problem is that I now need to list the values from columns A, B and AC automatically from the original sheet whenever a cell has been modified (so the rows can be identified) on the 'tracker' sheet. I would be grateful if anyone could help me adding three columns to the 'tracker' tab so the headers are:

Cell Changed | Old Value | New Value | Old Formula | New Formula| Time of Change | Date of Change| User | (Value from col A) | (Value from col B) | (Value from col AC)



The code I'm using is this one:

Please Login or Register  to view this content.

Many thanks