Formula for seperating data

[eechris]

I have a long list of names that i need to seperate out into the teams on
different sheets.

On the "team" worksheet in column I, I have the team names and I want each
on a seperate worksheet.

So on worksheet Green I want to get all member, columns A-C and G-H and have
them on the Green worksheet.

I have lots of data and do not want to use copy and past.

THANKS

 

[Gord Dibben]

See Ron de Bruin's site for code.

http://www.rondebruin.nl/copy5_4.htm

Adjust to suit.


Gord Dibben MS Excel MVP