Display from schedule

[ymcata]

Hi guys, I'm stuck with this:

On first sheet I have a schedule.
On second sheet I would like to display all data from a schedule.

I tried with pivot table and index-match formula, but i couldn't get solved.

Please help me,

matt

[Palmetto]

Brief synopsis of changes

Restructured schedule data to facilitate Advanced Filter and VBA
Created a dynamic named range for the data. Name = ClassSchedule
Formula for dynamic named range:=OFFSET(Sheet1!$N$1,0,0,COUNTA(Sheet1!$N:$N),10)
Created named list for Student Names (sheet3)
On Sheet2:
Applied Data Validation to cell B3 using list option (Name.List)

Automated Advanced Filter with VBA code to copy class schedule to sheet2.
Selection in B3 is passed to advanced filter and applicable records copied.

Created button (Forms Control) and assigned macro. macro name: Create_Schedule

Please Login or Register  to view this content.

IMPORTANT
Because you will likely have students with similar names, you need a unique identifier. At the moment, the code is filtering on a name, but this is not a good approach for the reason just stated. The code can easily be updated to work with a unique indentifier for the student. Post back if you need more help.

[ymcata]

Hey, thank you very much. You're genius for me!
But I can not understand all things.
Is it possible to auto restructure data or do i have to type it manually?
What am I doing wrong?

Thanky you very, very, very much.
Matt