Excel 97 Spread***

From: walk12 (walk12.1dmr0m_at_excelforum-nospam.com)
Date: 10/05/04 

Date: Mon, 4 Oct 2004 20:36:02 -0500

Hi,
I have a question about excel 97
I'm setting up an excel spread*** for a Reading Teacher.
She needs 4-columns called Names,Hearing/Sounds, Stanine, and
Writing/Vocabulary.
The question I have is the columns called (Writing/Vocabulary) and
(Hearing/ Sounds)will have scores and the teacher would like to click
on Desceding or Acsending and sort the scores to see which student
needs more help by checking lower scores.
How do I do that so that the scores will move with the names when she
sorts them?
Basically what I need is the 1st column would be (Names)
the 2nd would be (Hearing/Sounds) the 3rd would be (Stanine)
and the 4th would be Writing/Vocabulary.
The 2nd and 4th column would have scores. The teacher wants to sort by
scores to determine which student needs more help by looking at the
lower scores.
The names need to sort with the students scores.
If you could setup an example I could try out that would be awsome.
The way I gave for an example is how the spread*** needs to be
set-up
Any help would be greatly needed.

thanks walk12 :confused: 

-- 
walk12
------------------------------------------------------------------------
walk12's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=15011
View this thread: http://www.excelforum.com/showthread.php?threadid=266300