I am trying to create a function that will allow a user to select from a drop
down menu. Upon selecting an option, I want the other cells in this row to
automatically fill with the proper data. For example, if someone chose
English I, the room number and teacher name would automatically be filled in.
Can anyone point me in the right direction for this? Thanks.