I supervise the classes in computer skills at a middle
school. I need to set up a spread sheet to record each
student's weekly progress. If I make one worksheet for
each class, so that the teachers can enter the whole
class without changing worksheets, is there a way that,
at the end of the marking period, I can gather each
child's records onto a separate worksheet to see what
progress has been made? The best thing would be to make
a macro, so that I could create these individual sheets
often to see how the students are doing.

Hi MiriamS

Try this
http://www.rondebruin.nl/copy5.htm

--
Regards Ron de Bruin
http://www.rondebruin.nl


"MiriamS" wrote in message ...
I supervise the classes in computer skills at a middle
school. I need to set up a spread sheet to record each
student's weekly progress. If I make one worksheet for
each class, so that the teachers can enter the whole
class without changing worksheets, is there a way that,
at the end of the marking period, I can gather each
child's records onto a separate worksheet to see what
progress has been made? The best thing would be to make
a macro, so that I could create these individual sheets
often to see how the students are doing.