Winnie Ellerman
New Member
- Joined
- Oct 21, 2017
- Messages
- 2
Please help! I have been teaching myself excel to help out my school with a more efficient grade entering system. I am creating a workbook that has all the students marks entered in rows on the first sheet called Marks!, analysis of grades for the entire class on the second sheet called Analysis!, then subsequent sheets have each student's individualized report card called Report (1), Report (2), etc. The cells in the report card reference the Marks! Sheet in a lot of different places.
Is there any way to create a Report (2) sheet that increments each cell reference in Report (1) by one? I have to make 70 report cards and copying the formulas by hand leaves room for error and will take days.
When I looked at similar projects that people posted here, it seemed like there's a way to increment one cell but was lost trying to figure out how to do each reference, the same kind of way the autofill option works within on worksheet.
Is there any way to create a Report (2) sheet that increments each cell reference in Report (1) by one? I have to make 70 report cards and copying the formulas by hand leaves room for error and will take days.
When I looked at similar projects that people posted here, it seemed like there's a way to increment one cell but was lost trying to figure out how to do each reference, the same kind of way the autofill option works within on worksheet.