Hi there, Eduardo I know that you asked Caroline to give you an example but
I have one that I am working on now....if you could help...

I have a worksheet that contains data regarding contracts that we have. Now
in column A I have the contract number and line 1 may be the first # but then
line 2 maybe the contract number and A001 for an amendment. In another
column I have term dates. My boss wants me to sort by term date yet
everytime I do that, the contract #'s get mixed and I can't keep the
contract's and their amendments together. How can I lock lines together and
then sort so that the contract and its other line items stay together as a
"family"

Thanks! Deb

"Eduardo" wrote:

Hi Caroline,
Could you give an example of what you need, definetly what you are trying
below won't work since when sorting will change the order but the link will
stay with the cell you pointed. For sure there is a better way, please send
me an example

"Caroline" wrote:

Hello,
I'm linking cells from one workbook to another and I'm trying to get them to
"stick", even when the source book is sorted differently. I have tried
absolute and non absolute references but everytime I sort the source, it
screws up the results from my links.
There has got to be an easy fix :)
Thank you,
Caroline