Can anyone help me with this?
How can I filter the values in Table No. 1 by selecting from the dropdown list of Table No. 2 and thus populate the output in Table No. 3?
For example, if I choose grade A1 from the drop-down list in Table 2, I must get all students belonging to this class in Table 3 by name and academic number.
Thanks for the help in advance.
How can I filter the values in Table No. 1 by selecting from the dropdown list of Table No. 2 and thus populate the output in Table No. 3?
For example, if I choose grade A1 from the drop-down list in Table 2, I must get all students belonging to this class in Table 3 by name and academic number.
Thanks for the help in advance.
| الشعبة 2 وحد 1.xlsx | |||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| A | B | C | D | E | F | G | H | I | J | K | |||
| 1 | 1 | 2 | 3 | ||||||||||
| 2 | No | Name | Academic No | Class | Class | Name | Acadmic No | ||||||
| 3 | 1 | Tom | 123 | A1 | A3 | ||||||||
| 4 | 2 | Jack | 321 | A1 | |||||||||
| 5 | 3 | Roben | 456 | A2 | |||||||||
| 6 | 4 | Ali | 654 | A2 | |||||||||
| 7 | 5 | Nasser | 789 | A3 | |||||||||
| 8 | 6 | William | 987 | A2 | |||||||||
| 9 | 7 | Peter | 963 | A3 | |||||||||
| 10 | 8 | Tomas | 852 | A1 | |||||||||
| 11 | 9 | Moh'd | 741 | A1 | |||||||||
| 12 | 10 | Harry | 147 | A3 | |||||||||
Sheet1 | |||||||||||||
| Cells with Data Validation | ||
|---|---|---|
| Cell | Allow | Criteria |
| H3 | List | A1,A2,A3 |
