I think I understand what you're saying with the extra column but it seems
like a roundabout way and I'd have to make sure the source file is sorted
properly before I even look at the destination file -and these files are
shared, so it wouldn't be convenient.
Thanks anyways!

"Michael" wrote:

Insert a new column and create and index on it (i.e. 1,2,3. ...), naming it
original position, then you can sort back after the source file has changed.
--
If this posting was helpful, please click on the Yes button.
Regards,

Michael Arch.




"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