Generate a listbox

[patele]

I've search this forum and others and still haven't found what I need. I have a list of names on a worksheet in cells C9:C:C395. Their respected team numbers are located in G9:G395. What I'd like to know is it possible to put a team number in lets say cell K2 and have a listbox appear with the names of each of the team member from that team. Maybe a listbox is not the way to go for this so if you have any alternative suggestions I'd appreciate it. Thanks for any help given.

[Conor]

Are you planning to do something with the list of team member names - like select one for some purpose on the worksheet, or do you just want to see the list of players? Your answer will probably determine the best way to implement what you want.

Conor

[royUK]

Have a look at this example

[sglife]

I think it's what you need.

[patele]

Thanks to all 3 of you for your help. I will no doubt be using RoyUK's solution on a future project however for this one thanks to sglife my problem is solved. I appreciate you guys taking the time to help out. Again thanks to all.