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

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

A set-up along these lines using SUMIF & INDIRECT should help you get going
here

Assume identical structure source sheets are named as eg: Subject1,
Subject2, etc, with students names (or better, student IDs) listed in A2
down, test scores in C2 down

In your Summary sheet,
Enter* the source sheetnames in B1 across, ie: Subject1, Subject2, ...
You would have the same students names (or IDs) in A2 down
Place this in B2:
=SUMIF(INDIRECT("'"&B$1&"'!A:A"),$A2,INDIRECT("'"& B$1&"'!C:C"))
Copy B2 across/fill down to populate the test scores from each sheet

*Ensure that these match exactly with what's on the tabs (except for case)
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:19,000 Files:362 Subscribers:61
xdemechanik
---
"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

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