Just another play to try out ..

Assume the table below is in Sheet1,
cols A to J, headers (H1, H2, ... H9) in B1:J1
data from row2 down

---- H1 H2 H3 H4 H5 H6 H7 H8 H9
Sam 5 88 10 73 176 176 73 103 14.7
Harry 0 95 5 88 188 188 88 100 14.3
Beth 4 100 8 65 177 177 65 112 16.0
Sally 10 70 5 42 127 127 42 85 12.1
etc

Note that students' names are assumed unique in col A, and Sheet1 will be
assumed hidden away for privacy reasons, as required

In Sheet2 (this will be the enquiry sheet)
-------------
Let's set aside cell A1 for the input of the student's name
(Input a name into A1, say: Beth )

Paste the col headers (H1, H2, ... H9)
over from Sheet1 into A2:I2

Put in A3:

=IF(TRIM($A$1)="","",IF(ISNA(MATCH(TRIM($A$1),Shee t1!$A:$A,0)),"",INDEX(Shee
t1!B:B,MATCH(TRIM($A$1),Sheet1!$A:$A,0))))

Copy A3 across to I3

A3:I3 will display the results from Sheet1
for the name entered in A1, i.e. you'll get for "Beth"

Beth
H1 H2 H3 H4 H5 H6 H7 H8 H9
4 100 8 65 177 177 65 112 16

If the input in A1 is cleared, or if the name entered in A1 does not match
with those in col A in Sheet1, nothing [""] will show in A3:I3

--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <atyahoo<dotcom
----
"Sirvincent" wrote in message
...

Total Total Low Adjusted Final
Pt Test #1 Pt Test #2 Pt Test #3 Midterm Points Pt Test #4 Pt Final
Points grade points Average
Students #1 #2 #3 Test #4 #5 Test
Sam 5 88 10 73 176 176 73 103 14.71428571
Harry 0 95 5 88 188 188 88 100 14.28571429
Beth 4 100 8 65 177 177 65 112 16
Sally 10 70 5 42 127 127 42 85 12.14285714
0 0 0 0 0


I have a grade book and I wish to be able to blank out only indicated rows
thus allowing privacy to the students viewing the grades on screen.

I've attached my basic worksheet. As you can see I have frozen the
titles.
Now what I want to do is make everything beyond the first student
disappear
upon command and then reappear as needed.

Any ideas?