Custom Sorting a linked work sheet

[Derro]

Hi
I have a set of simple work sheets with cells containing formula. I have
linked the cells by the copy, paste and link method. I can cut and paste the
prime cells and the links follow. However when I do a custom sort of the
prime data the links remain and do not follow to the cells new location.
There must be a simple answer but I cannot find it and would appreciate help
on this question.

 

[Dave Peterson]

That's the way excel works.

Maybe you can find a unique key into that table sheet. Then you could use
=vlookup() or =index(match()) (using that unique key) so that you get the values
you want.

Debra Dalgleish has lots of notes:
http://www.contextures.com/xlFunctions02.html (for =vlookup())
and
http://www.contextures.com/xlFunctions03.html (for =index(match()))
and
http://contextures.com/xlFunctions02.html#Trouble

 

[Derro]

Thanks again Dave I will work around

That's the way excel works.

Maybe you can find a unique key into that table sheet. Then you could use
=vlookup() or =index(match()) (using that unique key) so that you get the values
you want.

Debra Dalgleish has lots of notes:
http://www.contextures.com/xlFunctions02.html (for =vlookup())
and
http://www.contextures.com/xlFunctions03.html (for =index(match()))
and
http://contextures.com/xlFunctions02.html#Trouble