Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formula for seperating data
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formula for seperating data
"eechris" wrote in message ... 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? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formula for seperating data
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
seperating data from one cell to multiple cells? | Excel Worksheet Functions | |||
Seperating Data From Lists | Excel Worksheet Functions | |||
Seperating text | Excel Discussion (Misc queries) | |||
Seperating Data within cells | Excel Discussion (Misc queries) | |||
Excel formula for seperating two words in the same cell. | New Users to Excel |