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

Linking messed up when Sorting
 

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