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