Spencer2005
New Member
- Joined
- Oct 20, 2019
- Messages
- 5
Hi
I’m hoping someone can help. I have a basic understanding of Excel but no knowledge of VBA.
I’m working on a school project where I have compiled a list of students and the course they are attending.
Worksheet 1 has a dropdown list containing student names in column D. When a name is selected, I want the adjacent cell in column E to populate with the course they are attending.
Worksheet 2 contains the student name in column A and the course name in column B.
I’m currently using VLookup to retrieve the info, but would prefer to use VBA. Can anyone help me with a code?
Thanks in advance!
I’m hoping someone can help. I have a basic understanding of Excel but no knowledge of VBA.
I’m working on a school project where I have compiled a list of students and the course they are attending.
Worksheet 1 has a dropdown list containing student names in column D. When a name is selected, I want the adjacent cell in column E to populate with the course they are attending.
Worksheet 2 contains the student name in column A and the course name in column B.
I’m currently using VLookup to retrieve the info, but would prefer to use VBA. Can anyone help me with a code?
Thanks in advance!