Linking Cells and applying a sort

[Destiny]

I'm looking for a way to have linked cells in multiple worksheets (1
workbook) stay linked when sorting? Any suggestions?

Thank you,

 

[Debra Dalgleish]

Linked cells will continue to refer to the original cell, if the source
data is sorted. For example, if the following names are on Sheet1:

Joe
Sam
Fred

And on Sheet2 you have links:

=Sheet1!A1
=Sheet1!A2
=Sheet1!A3

If you sort the dates on Sheet1, the links on Sheet2 won't follow the
dates to their new location in the list. So, Sheet2!A1 would be linked
to Fred, instead of Joe.

If you had manually entered other data on Sheet2, it would now be
associated with the wrong name.

 

[Destiny]

In other words, you're saying there is no way to lock the linked cells so
they maintain the correct information during a sort? Am I understanding that
correctly. I appreciate your help. Thanks so much!

Destiny

 

[Debra Dalgleish]

Yes, you're understanding correctly. The reference is to a cell, not to
the cell contents.

Perhaps you can enter all the data in one list, instead of two.
Or, copy and paste the original data to the second sheet, and update
both lists as required.