Hello.
Please see the attached Excel file.
Here, there are 3 sheets, "Score", "Students" and "Output".
I would appreciate it very much if you could help me with the VBA code that can do this:
Based on the list of names in "Students", go through the source data in "Score" to pick up the scores of the names that matches those in "Students" and publish these into "Output".
For example, the "Students" sheet here has 3 names (Luis Jamil, Michael Sin and Rebecca Holdom). Using the data from the "Score" sheet, the following would be published into columns A and B of "Output":
Name Score
Luis Jamil 35%
Michael Sin 47%
Rebecca Holdom 24%
Thank you very much
Bookmarks