Real-time data rewriting in one cell

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

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.

Please Login or Register  to view this content.

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

Great stuff, Leith!

I really appreciate it.

Best,

GusL