Hi Everybody,
I am working on student's marksheets and my excel spreadsheet is divided into two spread sheets. The first one contains a list of students and their marks and in the second one I'd like to create a report which will give me a summary of student's results and other details like college, group and level. By filling in his/her name in the name cell, I want all his/her details to appear in the report. What is the suitable function for such a case?
Looking forward to hearing from you.
Sumaia
I am working on student's marksheets and my excel spreadsheet is divided into two spread sheets. The first one contains a list of students and their marks and in the second one I'd like to create a report which will give me a summary of student's results and other details like college, group and level. By filling in his/her name in the name cell, I want all his/her details to appear in the report. What is the suitable function for such a case?
Looking forward to hearing from you.
Sumaia