I have an auto-updating list and I want to to save those data points every hour.

[CeaserHockey]

Dear Excel Geniuses,

I am trying to copy a cell every time it updates and put it in a new cell.

I am working in a sheet with different numerical values that automatically update every hour. These values are a2:a101. I want to record their changed values to the right of the original number every hour. For example a2:101 is the original, then b2:b101 is the value after an hour, c2:c101 is the value after 2 hours and so on.

I have tried everything I can to try to figure this out but it seems out of my skill level. I don't have any experience with vb within excel so if the solution involves coding please dumb it down as much as possible.

Thank you.

 

[Perpa]

CeasarHockey,
Welcome to the Forum.
I realize you were looking for something simple, but to see what is required, have a look at this link:

Scheduling Events With OnTime And Windows Timers
http://www.cpearson.com/Excel/OnTime.aspx

You should consider what happens if your original list 'a2:a101' is completed at 10:40 AM? Is it updated at 11:00 AM or 11:40 AM?

Here is some code to copy the 'values' in column A that might be used in the 'Your Code' as designated in the above link:

Sub UpdateMyData()
Dim LastCol as Long
LastCol = Cells(2, Columns.Count).End(xlToLeft).Column    'Finds last used column
Range("$A$2:$A$101").copy Range(cells(2,LastCol).Offset(0,1),cells(101,LastCol).Offset(0,1)).PasteSpecial xlValues
End Sub

Good luck!
Perpa

 

[Perpa]

CeaserHockey,

I was reading the Forum threads today and came across something simple that may work for you. Have a look at this link.
Perpa


Procedure/macro to run automatically every hour
https://www.mrexcel.com/forum/excel...edure-macro-run-automatically-every-hour.html