Linking messed up when Sorting

I have a question about linking. I wanted to link areport to 4 other reports
by department. I just tried it but if I sort the original report it screws up
the other reports. Is there a way of linking the appropriate line or person
so even when I sort it won't change?
Any suggestions would be greatly appreciateed!
Thanks!
Jugglertwo

Maybe...

If you can find a nice unique value in each row, you could use =vlookup() or
=index(match()) to return the data associated with that key.

You may want to read Debra Dalgleish's notes:
http://www.contextures.com/xlFunctions02.html (for =vlookup())
and
http://www.contextures.com/xlFunctions03.html (for =index(match()))



Jugglertwo wrote:
>
> I have a question about linking. I wanted to link areport to 4 other reports
> by department. I just tried it but if I sort the original report it screws up
> the other reports. Is there a way of linking the appropriate line or person
> so even when I sort it won't change?
> Any suggestions would be greatly appreciateed!
> Thanks!
> Jugglertwo

--

Dave Peterson