I made a gradebook in excel (using 2000, it's whats on the schools machines). I'm trying to change it around some, and could use some help. I know there are gradebook programs out there, but this is easier for me to customize.
I have several sheets in it (math homework, math classwork, reading, etc.) Each has a class list, and the rows across from them have grades:
Doe, John 3 5 3 1 0 5 and so forth.
What I want to do is have a report sheet that I can pull up to print for parents. I want to be able to tell in excel what student (I thought since each had their own row, I could do it by row number), and have it copy each of those rows (math homework, etc.) from the other sheets, and paste them on the report. That way I can send home a current report for each student.
But I want to be able to go to the report page, enter a number somewhere on it, and have it pull information from all other sheets, based on that number. It's probably something simple, but I've tried everything. So one sheet in a workbook, that can pull all information from a numbered row from each of the other pages and list it.
I hope I wasn't too long winded. Any help would be greatly appriciated.