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 ?
.....
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 ?
.....