How do I save a `snap shot' at an exact time of stream data

[Rayban123]

First and foremost, thank you for reading my post.

I have two spread sheets. The main spread sheets displays live streaming data. The second spread sheet (my sheet) captures and follows the live streaming data from the main spread sheet; and thus I can view this data on my spread sheet. It streams from 9am to 4pm.

I want to capture and save the data from one of the columns (and all 40 rows in that column) at exactly 11am. Whatever those numbers are at 11am, I want to those to stay static on my sheet, while on the main spread sheet they still stream. From 11:01 onwards, I will make my decisions for the rest of the day, based on whatever the data said at exactly at 11am.

Do I make sense, and can anyone help me please?

Thank you very much. And please feel free to contact me if I need to explain anything else. Thanks again.

 

[Derek]

Re: How do I save a `snap shot' at an exact time of stream

Hi there, welcome to The Board

Never worked with streaming data on a worksheet so this is just a guess that you might like to experiment with.

Paste this code into a standard module. Change column addresses as appropriate. Create a macro button on the spreadsheet and assign the first macro to it. Click this button before 11am each day to activate the macro. (you could also attach it to an open workbook event if you wish)

At 11am the macro will trigger and hopefully will copy whatever streaming data is then in Column A to Column B.


Sub ActivateOnTime()
Application.OnTime TimeValue("11:00:00"), "CopyColumn"
End Sub

Sub CopyColumn()
Columns("A:A").Copy
Columns("B:B").Select
Selection.PasteSpecial Paste:=xlValues, Operation:=xlNone, SkipBlanks:= _
False, Transpose:=False
Application.CutCopyMode = False
End Sub


Hope this is of some help
regards
Derek

 

[Rayban123]

Re: How do I save a `snap shot' at an exact time of stream

Hi Derek,


Thanks mate! Wow this borad is really cool.

I'm by no far an Excel expert but will most certainly give it a go. I'll let you know how I make out.


Cheers,