Copying data from different worksheet

Hi there,

I have the following data stored in different worksheets as shown below.

The format of the data shown in sheet below is divided by '|' where it represents a cell divider.

Sheet1
-------
A | B | C
ClassA | ClassB | ClassC

Sheet2
-------
A | B
ClassA | Student01
ClassA | Student02
ClassB | Student01
ClassC | Student02
ClassC | Student03
ClassC | Student04

Sheet3 - Final Output
-------
A | B | C
ClassA | ClassB | ClassC
Student01 | Student01 | Student02
Student02 | | Student03
| | Student04

Sheet3 = check if there is a match between Sheet1 and Sheet2, if there is, then use Sheet1 as a header (ClassA, ClassB, ClassC) and paste the matched data under the respective header.

Appreciate if anyone could help or advice on what is the best way to achieve the output shown in Sheet3? I guess, there could be a way to do it via a formula or something else.

I'm totally new with excel formula/macros/programming, so would really appreciate if anybody could help me on this.

I've also attached a sample data in the attachment file for your references.

Thanks a lot in advance.


- Blue

Welcome to the forum.

Please take a few minutes to read the forum rules, and then amend your thread title accordingly.

Thanks.

Hi Blu3St@r
I'm certain there's a more efficient way of doing this but...
The procedure in the attached seems to do what you require. Let me know if you have issues.

J

I'll look at this as soon as I can. J

Hi Blue
I thought I uploaded this revised book early this afternoon. Must not have hit the submit button. The revised procedure allows you to enter as many students as you please; it also allows as many classes as you wish (as long as they are in Sheet1 header, they will be included). Try the revision and let me know of any issues.
>

Hi Blue
You might try the attached. Certainly not the most elegant way to do this but it seems to work.

I've added a column of data on sheet2. I left it there so you could see what's happening. The data can be deleted when your satisfied as it will recreate itself in the procedure. Let me know if you have issues.

John