Can a cell be named so that when the sheet is sorted, the name refers to the
same data even though the position of the cell has changed?. I tried naming
cells with relative references (removing the "$" sign), but after sorting the
cell reference reverts to "A1".