Retrieving data from dynamically updated query cell only once (ignore the reference formula once the data is retrieved)

[Vince Black]

I'm using excel query to generate a table based on JSON style online data. This table is automatically updated each time the file is loaded or "Update All" button is pressed (this is how it should work). What I want to achieve is getting the cell data from this query table and paste it in the normal cell. Normally simple for example "=A1" formula would be enough to get the value but in my case after retrieving this data I need to make the value stay as it is (it should not be updated after query updates itself). Any idea how to implement it? Any chance for sample VBA code if it will be needed?


Thanks in advance.