I have two workbooks. One contains a large list of names with numbers in various columns. I have LINKED some numbers related to a name from the first workbook to their corresponding name in a second workbook. BUT – when the first workbook is sorted on various columns, the link on the second worksheet does not update. (I know moving a cell would keep the data correct, but SORTING ? ALL IS LOST?!)
So then, I tried giving each linked cell (in workbook 1) a NAME (DavidTotal, MarkTotal, etc.), and linked to those cells. When you sort, the named cells do not follow the row. (DavidTotal was in C45, and after sorting, David’s row is now row 32 let’s say, but DavidTotal is still cell C45).
VLOOKUP solutions won’t work, because with VLOOKUP the column must be sorted for the function to work, and the lookup column will be unsorted at times when sorting by other columns.
ANY IDEAS? Thank you. (Not sorting is the only answer I have at this point, but as numbers change, workbook 1 needs to be in this new order.)
