Cross Post >> How to maintain history of exam results

[leo73pk]

I want to maintain a history of exam results held on different dates

For this purpose I created a file with three sheets named Inputs, Working & result history. Description of all sheet is as follows :

“Inputs” Used as main Input file to feed marks for each subject on certain exam date.
“Working” Linked with sheet inputs and perform calculations (total marks, % etc)
“Result History” Date wise history of exam results based on sheet (working).



Required Solution Steps:

1. Score entered for different subjects in Sheet “Inputs” for a particular exam date.
2. Obtained marks are totaled and score % calculated based on scores entered in sheet inputs.
3. Date wise history of exam results recorded based on working sheet.

To transfer/copy/paste results from “Working” sheet to “Result history” sheet I recorded a macro which is linked with a button. This macro copy record from working sheet and paste it as value to result history sheet.