This step-by-step article shows you how to sort linked data without affecting cells that are linked to the original data.
If you create links to a range of cells and you sort the data to which thecells are linked, the linked cells are updated with the sorted data. This article contains an example that sorts linked data without affecting cellsthat are linked to the original data.
In the following example, the formulas in column D are linked to cells incolumns A and B. When you sort the data in columns A and B, the formulas incolumn D are not affected. To use this example, follow these steps: