Mark Duffy
New Member
- Joined
- Feb 18, 2002
- Messages
- 9
I have created a database listing courses which people have completed. (simple example below)
Name Course
Name A Course A
Name A Course B
Name A Course C
Name A Course D
Name B Course A
Name B Course B
Name B Course C
Name B Course D
What I am trying to do is when Name A is entered into another sheet, it lists all of the courses which that person has completed. I have tried all sorts of ways of doing this but all I can get is the first course that they have completed come up. Just to make sure you understand what I mean the example below should make it clear.
Name A Course A
Course B
Course C
Course D
Can anyone help me please
cheers
mark
Name Course
Name A Course A
Name A Course B
Name A Course C
Name A Course D
Name B Course A
Name B Course B
Name B Course C
Name B Course D
What I am trying to do is when Name A is entered into another sheet, it lists all of the courses which that person has completed. I have tried all sorts of ways of doing this but all I can get is the first course that they have completed come up. Just to make sure you understand what I mean the example below should make it clear.
Name A Course A
Course B
Course C
Course D
Can anyone help me please
cheers
mark