Keekp track changes

[DD]

I have excel with 100 records which will be update my another person.
I would like to keep what have been change for that 100 record, any tools to
track or how to do it ?

 

[Gary''s Student]

You can use a macro that will automatically insert a comment in a cell giving
the date and time whenever the cell is changed:

Install the following event macro in the worksheet code area:

Private Sub Worksheet_Change(ByVal Target As Range)
Dim r As Range
Set r = Target
r.NoteText Now
End Sub

 

[DD]

my scenario
in 1 Jan, i have 100 clients code with mailing address, then in 1 Feb i
pulled out from our internal system these 100 clients code with mailing
assress, therefor I want to know which client has changed the mailling
address.

For this case , can I use your seggestion ?

 

[dranon]

Put in a third sheet that has the following in cell A1:

=IF('1 Jan'!A1='1 Feb'!A1,"","CHANGED")

 

[DD]

Don't understand the 1 jan,

Eg, my sheet1 i have this record,

client name client address
lee blk 323
loo blk 456

sheet 2

client name client address
lee blk 888
loo blk 456

the client name lee address book have been chagne to 888. may be i have many
thousand of the client and 10 clients may change their client address.

how can i use the IF formula to detect the change of the client address ?