Convert Formula to Values when cell is NOT blank

[Smiles80]

Hi All,
I have a range of cells that are formula driven to capture values from a live feed, the values will change again within a matter of seconds and I want to capture the history. I'm trying to work out how I would convert cells in a range that are not blank into value to stop them from updating further.

Any help is greatly appreciated.

Thanks

 

[Fluff]

This seems to be the same as https://www.mrexcel.com/forum/excel...change-paste-extending-range.html#post5051407.

Please do not post the same question multiple times. All clarifications, follow-ups, and bumps should be posted back to the original thread.
Per forum rules, posts of a duplicate nature will be locked or deleted (rule 12 here: Forum Rules).

If you do not receive a response, you can "bump" it by replying to it again, though we advise you to wait 24 hours before doing and not to bump a thread more than once a day.