When I sort how do I keep cell references correct?
When I sort a table references to other cells are not maintained properly.
I've tried making them both relative & absolute & either way they no longer
point to the correct cell (which has moved) after the sort is completed.
These are all internal references (within the same table) but on a different
row.
|