hope I have understood the problem.

use autofilter and copy, operate from the sheet where you want to copy.
you can prepare a vba programme to find members of each of the teams.
just create macros and modify later into vba programme

another line of apprach will be to sort accoding to the column contiaining
team numbers




--
remove $$$ from email addresss to send email



Robert wrote in message
...
I have a list of team members numbers in one column and their
corrosponding
team numbers in another column. I would like display the teams seperately
on
other sheets automatically. I would like a formula that will search the
first
sheet, identify all team 1 members for example, and sort them numerically
on
a seperate team sheet. Previously, someone gave me this formula but I
can't
get it to work:
=INDEX(S7:S18,SMALL(IF(U7:U18=I2,ROW(S7:S18),ROW(1 :1)),1)) (at this point,
this is just a tester, so doesn't actually point to a different sheet)
any tips would be appreciated,
Robert