You probably want to set up some code that is event driven that copies the
value of that cell to another location so you have a permanent record. Not worked out completely, but try this. It should give you a notion of event driven code. In this case when a range changes.
Right click on the worksheet tab where you are working. View code
A vba window should open. Insert this code.
"vrange" should be the cell that changes
Quote:
Private Sub worksheet_change(ByVal target As Excel.Range)
Dim vrange As Range
Set vrange = Range("c8")
If Union(target, vrange).Address = vrange.Address Then
Call COPTOVALUES
End If
|
COPTOVALUES should be the code that copies the values to another cell.
That does not have to be added to the sheet code. That can be an ordinary module
Also go here.
http://www.java2s.com/Code/VBA-Excel...hangeevent.htm