See Ron de Bruin's site for code.

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

Adjust to suit.


Gord Dibben MS Excel MVP


On Wed, 27 Jan 2010 14:29:02 -0800, eechris
wrote:

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