Please help me to solve this

[Peteris]

I have a formula in a cell (marked with a circle) that has a range.

I move V6082 to the right - it is now in the range of the formula and result is updated.

Now, when I move V6082 back to the original position the range of the formula changes (red rectangle).

How do I prevent this from happening? I need the range to stay in place, not going with the cell when I move it. I need to move cells with mouse/drag because it is sensitive data and Ctrl-x/Ctrl-v is not an option. Also, dollar signs don't work in this regard.

Thanks.

 

[Peteris]

h

 

[Chrisdontm]

This may be too simple of an answer, but I'm not sure if I am following the question...
Have you tried naming the range w