View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
MiriamS MiriamS is offline
external usenet poster
 
Posts: 1
Default consolidating records

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.