How can I sample streaming data in spreadsheet (and not slow down my machine)

[buffalo]

Hi,

I receive streaming data in Excel Spreadsheet, lets call it: X in Cell A1 and Y in Cell A2 throughout the day. My goal is to record X and Y for every half hour (from 8AM EST to 5PM EST) in a new tab on same Excel spreadsheet.

Time Xdata Ydata
08:00 100 21.1
08:30 100 20.8
..
17:00 102 19.2

I have about 20 types of these (X,Y) streaming pairs, so will be populating 20 separate tables. I would really prefer my machine to not slow down because of this. Could you suggest how I could populate my spreadsheet tab with these half-hourly samples?

thanks
b

 

[buffalo]

Can somebody help me with this please?