I'm trying to sort data alphabetical, which I know how to do and have the
information related to it to move with the sort. The issue the data is
linked to another workbook and that information is incorrect when we sort the
data, because the cell references have changed. How do we get the information
to be correct in the workbook the data is linked with ?