Information Flow to a main spreadsheet

[Guest]

Hi, I know how to link worksheets basically. My problem is interesting though.
I have to do this in Excel....I can't use Access.

I 3 worksheets that have people's names and groups of classes they took.
Each worksheet has a different group of classes.

I would like to know if I can have a Main worksheet that has all 3 sheets
worth but when it flows into it the person's name only appears once.

Each core worksheet may look like this.

Name Class A Class AA Class AAA

the next sheet would be

Name Class B Class BB Class BBB

and so on for the 3rd sheet.

Can I have that 4th sheet that compiles the other 3?

Name Class A Class AA Class AAA Class B Class BB .....and so on?
Is this possible without having that persons name come up 3 times?
Thanks in advance!

 

[Guest]

i think so !I f you have a vlookup on the persons name the columns to the
right can be class a class aa class b clasbb classc classcc etc etc etc

 

[Dave Peterson]

I would start by creating that 4th worksheet.

Copy all the names from each of the 3 sheets to column A of the 4th sheet.
(Include just the first header row.)

You'll end up with duplicates for those who took multiple classes.

But you can eliminate the duplicate names by using Data|Filter|Advanced filter.

Debra Dalgleish has detailed instructions at:
http://www.contextures.com/xladvfilter01.html#FilterUR

This'll give you a nice list (in column B) of unique names.

Delete column A (we're done with it).

Now use =vlookup() to return each of the classes to the new column B, C, and D.

If you've never used =vlookup(), visit Debra Dalgleish's site:
http://www.contextures.com/xlFunctions02.html
for nice instructions.