Database problem

[Mark Duffy]

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

[Derek]

Mark
Please tell me is the name is in one column and the course in the next, or is it all in one column?

If it is in separate columns I can e-mail you a spreadsheet that I have recently completed that does just what you want.

[ This Message was edited by: Derek on 2002-02-21 06:46 ]

[Mark W.]

Use an Advanced AutoFilter with a criteria range on your other worksheet.

[Mark Duffy]

Derek,
They are in seperate columns,

I would be very grateful if you could send me the spreadsheet that you did so I can see how to do it.

Thankyou very much!!!!!!
Mark D