sorting with linked worksheets

[Guest]

I have 2 worksheets that are linked together. On worksheet A I have First
and Last name along with some other information. Worksheet B it is linked to
have the First and Last name automatically put in for a seperate report. In
worksheet B additional data is added such as test scores. When I sort
Worksheet A to alphabetize the names worksheet B names are then alphabetized
but the test scores do not change with the names. Is there a trick to
sorting linked data so I can have the names in alpha order and the test
scores will move with it.
New names are added over a several month period so I am needing to sort each
week.
I am using Excel 2003
Thanks

 

[Dave Peterson]

If you have formulas that look like:

=sheet1!a2

Then you're going to have trouble when you sort sheet1.

Maybe you can put the names in the second sheet (as values--not formulas), then
use =vlookup() to retrieve values from other columns based on matching that
name.

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()))