Two sheet, identical except for the test and test results.

"Sheeloo" wrote:

How many sheets do you have?

One sheet has Student and his grade? Others Student, Test, Result?

Do you have a list of all students? Does Student col has any duplicate values?
--
If you find this post helpful pl. choose "Yes"...


"Sprowler" wrote:

I have a data base in excel that lists test info on students. There are
multiple tests on various sheets. The sheets are almost identical except for
the test being different and thus the results. How do I combine the sheets
into one sheet, that will have the student's name lined up on one continuous
line? I can then delete the columns that are duplicated but have the test
info on one line.

Student, grade, test a, result

Then on another spread sheet the info is the same but the test is different
info is different.

I am looking for:

student, grade, test a, result, test b, result.

I think this can be done but I need some help please.

Thank you in advance.

Susan