Linking cells in one worksheet to another that can be sorted

Copper Contributor

I have a workbook that contains a master sheet of residents in a condo association with personal data, one utility worksheet for lists, and 46 individual account worksheets (one for each resident). I link the personal data from the master sheet to cells on the individual sheets so it can be repeated in the individual sheets. If I sort the data on the master sheet to alphabetize it the links in the individual sheets stay with the original cell locations rather than follow the new cell location in the master sheet. How do I get them to follow the new positions?

2 Replies

@James_Stallcup you should use the XLOOKUP (since you tagged Office365) for that. See example in the attached workbook.



best response confirmed by James_Stallcup (Copper Contributor)
Thanks. I did.