Students names ( on normal cells) changed automatically when i select a class from dropdown list.

[Omarom]

Students names ( on normal cells) changed automatically when i select a class from dropdown list :
How can i do this via formulas or via vba?
for example:
"dropdown list " : [Class 6-1 Class 6-2 - Class 6-3 ]
Student name 1 Student name 2 student name 3
Student name 2 Student name 2 student name 3
Student name 3 student name 2 student name 3

I don't mean the dependent list, it's something else
dependent list make a filter for each cell, so i dont want to select a student name for each cell!
Any one can help me ?
.....

 

[onlyadrafter]

Hello,

where is all your data located and how is the 'Class' selected? Is it drop down dox or data validation?

Do an advanced search for 'usa and france' by Aladin.

 

[Omarom]

Hello,

where is all your data located and how is the 'Class' selected? Is it drop down dox or data validation?

Do an advanced search for 'usa and france' by Aladin.

Hi,
thank you for your reply
it's a data validation, I choosed "list" from data validation openbox.
Student data at the same workbook, the same sheet or another sheet.
I have attached an excel file which expressing the table and problem.
Please change the extension from (.png) to (.xlsx)
thanks

 

[Omarom]

Hi,
thank you for your reply
it's a data validation, I choosed "list" from data validation openbox.
Student data at the same workbook, the same sheet or another sheet.
I have attached an excel file which expressing the table and problem.
Please change the extension from (.png) to (.xlsx)
thanks

Sorry, the file cannot be uploaded any way
this is another link

Dependent list.xlsx

drive.google.com

thanks

 

[Fluff]

How about

=FILTER(B2:D8,B1:D1=H2)

 

[Omarom]

How about

=FILTER(B2:D8,B1:D1=H2)

Hi Dear
It working!
thank you very much!

 

[Fluff]

You're welcome & thanks for the feedback.