Track multiple changes in one cell

[Guest]

It looks like this can't be done but I wanted to make sure. I have highlight
changes set to on but I noticed that it seems to only track the last change I
made to the cell. What if I make multiple changes to the same cell and I want
to keep track of all of them?

 

[Frank Kabel]

Hi
not possible with the build-in feature

 

[Debra Dalgleish]

You can list the saved changes on a History sheet:

Choose Tools>Track Changes>Highlight Changes
Add a check mark to List changes on a New Sheet
Click OK

 

[Gord Dibben]

Nick

You could use a worksheet_change event macro to enter the contents of the
input cell into column B at the next available empty row.

Private Sub Worksheet_Change(ByVal Target As Excel.Range)
On Error GoTo stoppit
If Target.Address = "$A$2" And Target.Value <> "" Then
ActiveSheet.Cells(Rows.Count, 2).End(xlUp) _
.Offset(1, 0).Value = Target.Value
End If
stoppit:
End Sub

Right-click on your sheet tab and select "View Code". Copy the above code
into the module that opens.

Using A2 as the input cell, any new number entered will be automatically
placed into Column B(starting at B2)at the next available empty row.

Note: if a mistake is made in last entered number in A2 , you will have to
delete the contents of the last cell in Column B then re-enter in A2.

Gord Dibben Excel MVP