Hello,
I have a sheet (sheet1) listing team members and other info including the
player number in column A and the team number in column G. This sheet is
sorted in order of player number, (i.e., column A).
I have a second sheet (sheet2) that shows the teams seperately and which
players are in them. Currently, I have to manually enter the team members
numbers again on sheet2 (column A). (I have some lookup functions to get the
other member info once the member number is filled it, so most of it is
automatic.) I would like my sheet2 to be smarter and automacally fill in the
member numbers from sheet1 as well. Above each team on sheet2 is a header
cell that indicates the team number.
Basically, I want to match the cell on sheet2 which contains the team number
to the team numbers in column G on sheet1 (except there will be more than one
match, so it won't be a simple match), then bring the team members over to
sheet2 that are in the corrosponding team, and avoid duplications in the
process.

thanks in advance for any ideas...
Robert