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.
Bookmarks