I have several cells that refer to this range 'Aker BP Data'!B$2:B$1044 and 'Aker BP Data'!I$2:I$1044.

Problem is, if there are changes to these ranges I have to go edit each cell that contains reference to these ranges.


Let`s say I want to change the reference in the formula from 'Aker BP Data'!B$2:B$1044 to 'Aker BP Data'!B100:B$500. Could the range be assigned to one single cell so I can alter this more easily?

Thank you for your help!