ExcelBanter - How freeze streaming data at specific point in time?

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - How freeze streaming data at specific point in time? (https://www.excelbanter.com/excel-discussion-misc-queries/69854-how-freeze-streaming-data-specific-point-time.html)

Bob Smith

How freeze streaming data at specific point in time?

Believe I need to paste values to another location, but can't see a way to do
this directly in Excel spreadsheet. Does this need to be in a macro, VB, or
am I on the wrong track?

Thanks, Bob Smith

All times are GMT +1. The time now is 02:03 AM.