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

Rayban123

New Member
Joined
Jan 28, 2004
Messages
5
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.
 

Excel Facts

Return population for a City
If you have a list of cities in A2:A100, use Data, Geography. Then =A2.Population and copy down.

Derek

Well-known Member
Joined
Feb 16, 2002
Messages
1,592
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

New Member
Joined
Jan 28, 2004
Messages
5
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,

(y)
 
Master Excel Bundle

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

Forum statistics

Threads
1,151,896
Messages
5,766,992
Members
425,392
Latest member
Booknerd

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