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

 

[George]

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

Can you not just use sort data and sort by colour and it will put everyone
with the same colour together. then you only need to copy and paste for the
number of teams you have?

 

[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