Moving Data

marklongbottom

Board Regular
Joined
Dec 1, 2004
Messages
52
I have a row of data (A4:I4) which is being fed in from an external source. This data refreshes every minute in these cells. Every minute that it changes I would like to take a snap shot of this data and put it in another row below e.g. A7:I7. The next minute I'd like a snap shot of A4:I4 to go in to A8:I8 and so on.
Is this possible? Can someone help?

Cheers,
Mark
 

Excel Facts

Whats the difference between CONCAT and CONCATENATE?
The newer CONCAT function can reference a range of cells. =CONCATENATE(A1,A2,A3,A4,A5) becomes =CONCAT(A1:A5)

Andrew Poulsom

MrExcel MVP
Joined
Jul 21, 2002
Messages
73,092
Put a formula somewhere that references A4. Set calculation to automatic and try this code in the module for the worksheet:

Code:
Private Sub Worksheet_Calculate()
    Dim NextRow As Long
    NextRow = Range("A" & Rows.Count).End(xlUp).Row + 1
    Range("A4:I4").Copy Range("A" & NextRow)
End Sub
 

Watch MrExcel Video

Forum statistics

Threads
1,130,346
Messages
5,641,598
Members
417,225
Latest member
LukiiMaxim96

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top