user form data grouping

Hi

actually i need user groups, thats consits team name and users under this team.
there may be any number of teams and users,
the idea is, when i click on team name, the users under that team should appear and vice versa..

if u can help me this, im happy...
thank you

Nick's picture

put your data in the

put your data in the following format:

Team Name
a Bob
a Ben
b Chris

- then add a pivot table, and add "Team" to the row field, and "Name" also to the row field, you will have what you need.

more here:
http://excelexperts.com/Teach-Yourself-Excel-Lesson-25-Create-A-Pivot-Table