Im importing web data and i have to trim it with a Macro, which it does effectivly. However if i use a formula to calculate some statistics, even if i place it outside of the range, it vanishes when refreshing the imported web data. How can i fix this?WHLdb (Automatisch opgeslagen).xlsm

I attached the file.

Thanks in advance