Thanks for your good works.
I have a workbook that calculates students scores in an academic session. Each worksheet represent each subject. The report sheet is designed to pull the scores of each student from the different work sheet to produce a report card for the pupil.
My question:
From a drop down tab on the report sheet worksheet, how do i pull all the students score to the table below by selecting the name on the drop down list? Also, how do i create report for each term?
workbook attached.
Thank you
I have a workbook that calculates students scores in an academic session. Each worksheet represent each subject. The report sheet is designed to pull the scores of each student from the different work sheet to produce a report card for the pupil.
My question:
From a drop down tab on the report sheet worksheet, how do i pull all the students score to the table below by selecting the name on the drop down list? Also, how do i create report for each term?
workbook attached.
Thank you