Extracting results of student from result sheet to print out

chattycapulet4u

New Member
Joined
Sep 22, 2017
Messages
1
Hello, I want an excel program that will extract the contents (values of results) from the sheet (HND 1 FIRST) and display it as a sample of the first student (ABIODUN RACHAEL).

  1. Out of the labels (Name, Matric No, Department, Programme, Session), the matric no will be the variable to use to get the name and the corresponding student.
  2. The student results will automatically extracted into the new page for printing like the sample attached.
  3. The Course Codes, Course Units and Course Titles are in the attached document as (COURSE)
  4. In the each student result, the row with alphabet codes A, B, C, D, F, AB represent Grade column in the corresponding print result.
  5. In the each student result, the row next to the grade’s row is the score row which is the actual score for each course and the value is expected to be copied into the score column in the print result page
  6. In the each student result, the row next to the score’s row is the point row which is the actual point the student get for each course and the value is expected to be copied into the Credit Point column in the print result page
  7. In the table below in the print result page, TCP is the total credit point of the whole courses boldened under Credit Point column. TNU is the total unit of the offered courses boldened under Unit column in the print result page. GPA is the grade point.
  8. Previous TCP, TNU, and GPA is empty because the results is the first of it kind for the set of the student while Cummulative GPA, is the same values with the present GPA because it is the result of first semester.
  9. Course Still Outstanding (CSO), represent courses that the student failed with grade of (F or AB) in the main result such as student with serial no 12, 15, 17, 26, 33, 38, 40, 41, 42 and 44. The student with course that carries this grade F or AB, should have the corresponding course code be copied infront of the CSO.

Thanks in anticipation
 

Excel Facts

Do you hate GETPIVOTDATA?
Prevent GETPIVOTDATA. Select inside a PivotTable. In the Analyze tab of the ribbon, open the dropown next to Options and turn it off

Forum statistics

Threads
1,223,098
Messages
6,170,100
Members
452,301
Latest member
QualityAssurance

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top