Recording the First Change of a Cell Value

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a spread sheet that looks like so before the start
of the trading day:
 
Carl -

How does that cell get updated?

If it's from a live feed from some online data source, then you probably
ought to post this in the Excel.Programming NG where you may find an answer.

If it's updated manually, then you need only write a worksheet change event.
Something like

Private Sub Worksheet_Change(ByVal Target As Range)
With Target
If .Column = 2 And .Row = 5 Then .Offset(0, 1).Value = Target.Value
End With
End Sub
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Recording the first change in the value of a cell 1
Capturing The First Change in a Formula 9
Update cell value based on name and specific date 1
Excel 2003 make 1 date cell automatically change another date cell 3
Excel Monthly Spread sheet. 12
formula 2 display selected objects ONLY in new sheet from another 1
Conditional formatting 2
Capturing First Change In A Cell 4

Back
Top