Hi,

I'm a teacher and currently have set up a spreadsheet containing pupils
marks and grades. I have in column A the pupils names going down and across
row 1 I have the various headings of assessments. I'm working in excel 07 as
well.

What I am looking to do, is set up some kind of standard sheet that will
when selecting a pupil's name will display all their marks creating a form
of summary sheet for their records about A4 size.

Im not sure if its possible to design it in Word and use a kind of database
'next and previous' kind of system for the programme to move to each pupil
and look up the marks inputting the ones I want to be displayed?

Thanks.