How to record data every 30 minutes in Excel spreadsheet?

[buffalo]

Hello,

Cell A1 has data that keeps changing over time, and I would like to record this data, on the same spreadsheet. From time 8am EST to 5pm EST. Can you help me please? I would prefer this code would not slow my machine down.

Time Data
08:00 100
08:30 150
..
17:00 102

regards

 

[JD_GFI]

I think the "Application.OnTime" function in VBA is what you're looking for. The only part I'm not sure of is whether the workbook has to be open for the scheduler to keep working or whether you could combine it with the windows task scheduler and a "Workbook_Open" event.

 

[buffalo]

thanks much.

I'll leave it open when needs to be recorded. Only question is will this slow down my machine as I will be capturing data from 50 cells, every 30 minutes.

thanks

 

[JD_GFI]

It shouldn't be noticeable but it would depend on whatever else was running on the machine at that time really. Easiest way to check is to run it with task manager open