Freeze cell with result; don't move cell when adding new lines

[rolive]

I need my Result From F10 never to be moved from that Cell.
Is there a way to add cell above F10 but not movig the result from the cell?

I'm working with importrange, and when someone adds a new cell, everything mess up;

Any help? Thank in advance!

https://docs.google.com/spreadsheets...DX4/edit#gid=0

[FDibbins]

Is there a way to add cell above F10 but not movig the result from the cell?

Short answer - I dont believe so.

Can you put that somewhere else?
What is the data range you are importing?
Also, not all members are able (or willing) to access files from file-hosting sites, so please upload your sample workbook here