Thanks Thanks:  0
Likes Likes:  0
Results 1 to 4 of 4

Thread: Database problem

  1. #1
    New Member
    Join Date
    Feb 2002
    Location
    Nottinghamshire, England
    Posts
    9
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    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

  2. #2
    Board Regular
    Join Date
    Feb 2002
    Location
    Perth Australia
    Posts
    1,584
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    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 ]

  3. #3
    MrExcel MVP
    Join Date
    Feb 2002
    Location
    Austin, Texas USA
    Posts
    11,654
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

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

  4. #4
    New Member
    Join Date
    Feb 2002
    Location
    Nottinghamshire, England
    Posts
    9
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    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


Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •