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