Home |
Search |
Today's Posts |
#1
|
|||
|
|||
How can I get individual reports from excell gradebook?
I want to write progress reports for each student, based on the information
entered in an Excel gradebook. How can I do this, so that the name of each assignment and it's points appears on an individualized report for each student? |
#2
|
|||
|
|||
It depends on how your gradebook is set up. For example,
if you had names in column A, with assignments in row 1 and grades across the columns: Name Assignment #1 Assignment #2 Assignment #3 Jack A B B Melissa B+ B+ B John A A- C+ Diana B+ A+ A Luke C- C B- You could apply an AutoFilter (Data Filter AutoFilter) and filter by name in col. A. Then Print. Or you could even use a simple macro like the one below to print each student and their scores on an individual pages: Sub PrintGradesbyName() Dim LastRow As Long Dim i As Long LastRow = Cells(Rows.Count, 1).End(xlUp).Row With ActiveSheet .PageSetup.PrintTitleRows = "$1:$1" For i = 2 To LastRow .Rows(i).PrintOut Copies:=1, Collate:=True Next i End With End Sub --- To use, copy the code above, press ALT+F11, go to Insert Module, and paste in the code. Then Press ALT+Q to close VBE. In XL, go to Tools Macro Macros and run the macro. HTH Jason Atlanta, GA -----Original Message----- I want to write progress reports for each student, based on the information entered in an Excel gradebook. How can I do this, so that the name of each assignment and it's points appears on an individualized report for each student? . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Can I view an excell document without excell (not installed wit. | Excel Discussion (Misc queries) | |||
Can I view an excell document without excell (not installed wit. | Excel Discussion (Misc queries) | |||
lable ranges in Excell | Excel Discussion (Misc queries) | |||
Why can't we see or access MS Excell 2003 even though we have MS . | Setting up and Configuration of Excel | |||
EXCELL 2002 Glitch???? | Excel Discussion (Misc queries) |