I have a sheet with data in a range of cells, say for example A1:J6. In another part of the same sheet, I have cells that link to the ones in that range (A1:J:6).
If I insert cells into A1:J6 and add data (so now my range of cells with original data is A1:L6), the linked cells in the other part of the sheet automatically update with the correct cell reference and show the same (desired) information as before. However, if I sort the range A1:J6, the linked cells don't update, but keep their original cell references, and now show different information, which is not what I want.
Any ways around this? How can I sort A1:J6 and have the linked cells update to the new positions of their originally linked-to-cells?
Hope this makes sense and thanks for your help.