Volatile data (dynamic or refreshed) Capture and Locked

[Mike Slattery]

I am importing stock data and ticker symbol from a page that gets refreshed often.

What is the most effective way to automatically keep the data that was derived from the data download and stop it from refreshing from the cell addresses that it came from?

Thanks,

Michael