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
--
paul
remove nospam for email addy!



"KenRamoska" wrote:

> 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!