The title's probably confusing so I'll try and explain. I've created a worksheet that is connected to some trading software. From that software I'm able to link a countdown clock for a particular market into a cell in Excel, this countdown clock signifies the time remaining until the KO of a football match and counts down until 00:00:00 (which is KO). Using this clock would it be possible at say 10 minute intervals for Excel to copy and paste data from one set of cells to another?

For example I have the countdown clock in B1. The data I want to copy is in the range AA2:AC21. The destination cell to paste into is V2. The data in AA2:AC21 is updating at 500ms and hence is constantly changing, the paste part needs to just be the static values if that makes sense.

Not sure if this is possible but thought i'd check it out anyway. Thanks in advance for any advice.