Real-time data rewriting in one cell

[GusL]

Hi!

I have a spreadsheet with real-time data refreshing every few seconds in one cell (say, in A2). I would like each data point to be sent to the B column, i.e., every time I start collecting data, the "live" A2 cell should write me a string B2....Bn.

Is there any simple way to do this?

Thank you folks in advance for your help,

GusL

[Leith Ross]

Hello GusL,

Welcome to the Forum!

Here is macro to take the value of A2 and store it in B2 on down, every time A2 changes.

Private Worksheet_Change(ByVal Target As Range)

  Dim NextRow As Long

  Application.EnableEvents = False
    If Target.Address = "$A$2" Then
       NextRow = Cells(Rows.Count, "B").End(XlUp).Row + 1
       Cells(NextRow, "B") = Target.Value
    End If
  Application.EnableEvents = True

End Sub

How to Save a Worksheet Event Macro
1. Copy the macro using CTRL+C keys.
2. Open your Workbook and Right Click on the Worksheet's Name Tab for the Worksheet the macro will run on.
3. Left Click on View Code in the pop up menu.
4. Paste the macro code using CTRL+V
5. Save the macro in your Workbook using CTRL+S

Sincerely,
Leith Ross

[GusL]

Great stuff, Leith!

I really appreciate it.

Best,

GusL