Hello folks,
I have a list of students and the classes they are taking (Sheet1) and I have a ledger (Sheet2).
Sheet1:
<colgroup><col><col><col><col span="3"></colgroup><tbody>
</tbody>
Sheet2:
<colgroup><col><col><col span="4"></colgroup><tbody>
</tbody>
I have put a vlookup function in the ledger (sheet2) where, if i put the student id the student name populates in the next cell. What i need now is a drop down menu in the column next to it with ONLY the names of classes that respective student is taking. And once a transaction is recorded in the ledger that students payment and balance amount needs to be automatically updated on sheet1.
I hope this explained my problem sufficiently. I am new to this so please bear with me. should there be any question please let me know. thanks
I have a list of students and the classes they are taking (Sheet1) and I have a ledger (Sheet2).
Sheet1:
Student ID | Student Name | Class | Total Amount | Total_Paid | Balance |
101 | Student Name 1 | Math | 150 | ||
101 | Student Name 1 | Science | 150 | ||
101 | Student Name 1 | Geography | 80 | ||
101 | Student Name 1 | History | 80 | ||
101 | Student Name 1 | P.E. | 50 | ||
101 | Student Name 1 | Arts | 50 | ||
102 | Student Name 2 | Science | 100 | ||
102 | Student Name 2 | Geography | 100 | ||
102 | Student Name 2 | History | 75 | ||
102 | Student Name 2 | P.E. | 10 | ||
103 | Student Name 3 | Math | 200 | ||
103 | Student Name 3 | Science | 250 | ||
103 | Student Name 3 | Geography | 100 | ||
103 | Student Name 3 | History | 55 | ||
103 | Student Name 3 | P.E. | 50 | ||
103 | Student Name 3 | Arts | 50 | ||
103 | Student Name 3 | Biology | 80 | ||
103 | Student Name 3 | AP | 300 |
<colgroup><col><col><col><col span="3"></colgroup><tbody>
</tbody>
Sheet2:
S_ID | S_Name | Class | Date | Debit | Credit |
101 | Student Name 1 | ||||
<colgroup><col><col><col span="4"></colgroup><tbody>
</tbody>
I have put a vlookup function in the ledger (sheet2) where, if i put the student id the student name populates in the next cell. What i need now is a drop down menu in the column next to it with ONLY the names of classes that respective student is taking. And once a transaction is recorded in the ledger that students payment and balance amount needs to be automatically updated on sheet1.
I hope this explained my problem sufficiently. I am new to this so please bear with me. should there be any question please let me know. thanks