ExcelBanter - Overwriting of linked data

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Overwriting of linked data (https://www.excelbanter.com/excel-discussion-misc-queries/28930-overwriting-linked-data.html)

kivar

Overwriting of linked data

How can I prevent linked data from bring overwrited, when I have a formula
which is dependent on the date. For example, if the date is 1st June, then
the respective data from the date is taken. However, when the date is 2nd
June then I lose the data which was extracted the previous day. Is there any
way I can prevent this from happening?

All times are GMT +1. The time now is 10:20 PM.