Transfer data automatically from RTD cells to new ones

Hello! I am new to Excel VBA and have come across multiple problems, but thankfully internet always provides good answers.

In this case: a cell is filled with data and updated every minute with the help of the RTD function. I need to transfer those data to another cell before each minute, so that the new data can be compared to the older ones. How could this be achieved through VBA?

Thank you in advance.

Aki