Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Search & Refine Raw Data
I have a tab with 60 names in column A with at least 70 entries per
person on seperate rows [going from col A to L] These 60 names belong to 5 teams and I would like to be able to run a macro to search for the 12 names per team and then place them onto a seperate tab for each team. That is my ideal, failing that even splitting them into teams on one tab would greatly reduce the time it currently takes to perform this task. Hope someone can help! Thank you. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Search & Refine Raw Data
Providing you have a column which indicates "Team Number", then just do Data
Filter AutoFilter and select the arrow at the top of the TeamNumber column and choose whichever team you wish to view.......when finished, just do Data Filter Autofilter again to return things to normal.......... hth Vaya con Dios, Chuck, CABGx3 "bbibib" wrote: I have a tab with 60 names in column A with at least 70 entries per person on seperate rows [going from col A to L] These 60 names belong to 5 teams and I would like to be able to run a macro to search for the 12 names per team and then place them onto a seperate tab for each team. That is my ideal, failing that even splitting them into teams on one tab would greatly reduce the time it currently takes to perform this task. Hope someone can help! Thank you. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Search & Refine Raw Data
Unfortunately, no team number is available!!
I wish it was..... Thanks for the reply. CLR wrote: Providing you have a column which indicates "Team Number", then just do Data Filter AutoFilter and select the arrow at the top of the TeamNumber column and choose whichever team you wish to view.......when finished, just do Data Filter Autofilter again to return things to normal.......... hth Vaya con Dios, Chuck, CABGx3 "bbibib" wrote: I have a tab with 60 names in column A with at least 70 entries per person on seperate rows [going from col A to L] These 60 names belong to 5 teams and I would like to be able to run a macro to search for the 12 names per team and then place them onto a seperate tab for each team. That is my ideal, failing that even splitting them into teams on one tab would greatly reduce the time it currently takes to perform this task. Hope someone can help! Thank you. |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Search & Refine Raw Data
If you know a list of the names for each of the teams, you could put together
a VLOOKUP table (names down one column and coresponding teamnumber down the one to the right of it) and using a helper column, insert a VLOOKUP formula to create a TeamNumber column....from there, Copy PasteSpecial Values to get rid of the formulas, and then use the AutoFilter as previously described. Vaya con Dios, Chuck, CABGx3 "bbibib" wrote: Unfortunately, no team number is available!! I wish it was..... Thanks for the reply. CLR wrote: Providing you have a column which indicates "Team Number", then just do Data Filter AutoFilter and select the arrow at the top of the TeamNumber column and choose whichever team you wish to view.......when finished, just do Data Filter Autofilter again to return things to normal.......... hth Vaya con Dios, Chuck, CABGx3 "bbibib" wrote: I have a tab with 60 names in column A with at least 70 entries per person on seperate rows [going from col A to L] These 60 names belong to 5 teams and I would like to be able to run a macro to search for the 12 names per team and then place them onto a seperate tab for each team. That is my ideal, failing that even splitting them into teams on one tab would greatly reduce the time it currently takes to perform this task. Hope someone can help! Thank you. |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Search & Refine Raw Data
I was hoping a macro would be the saviour, I'll try the VLOOKUP but
that is an area of excel that I am not too familiar with.... Thanks anyway - have to resign myself to a repetitive strain injury! CLR wrote: If you know a list of the names for each of the teams, you could put together a VLOOKUP table (names down one column and coresponding teamnumber down the one to the right of it) and using a helper column, insert a VLOOKUP formula to create a TeamNumber column....from there, Copy PasteSpecial Values to get rid of the formulas, and then use the AutoFilter as previously described. Vaya con Dios, Chuck, CABGx3 "bbibib" wrote: Unfortunately, no team number is available!! I wish it was..... Thanks for the reply. CLR wrote: Providing you have a column which indicates "Team Number", then just do Data Filter AutoFilter and select the arrow at the top of the TeamNumber column and choose whichever team you wish to view.......when finished, just do Data Filter Autofilter again to return things to normal.......... hth Vaya con Dios, Chuck, CABGx3 "bbibib" wrote: I have a tab with 60 names in column A with at least 70 entries per person on seperate rows [going from col A to L] These 60 names belong to 5 teams and I would like to be able to run a macro to search for the 12 names per team and then place them onto a seperate tab for each team. That is my ideal, failing that even splitting them into teams on one tab would greatly reduce the time it currently takes to perform this task. Hope someone can help! Thank you. |
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
Search & Refine Raw Data
I just got home and don't see an email, so I guess you got it
sorted........... Vaya con Dios, Chuck, CABGx3 "bbibib" wrote in message ups.com... I was hoping a macro would be the saviour, I'll try the VLOOKUP but that is an area of excel that I am not too familiar with.... Thanks anyway - have to resign myself to a repetitive strain injury! CLR wrote: If you know a list of the names for each of the teams, you could put together a VLOOKUP table (names down one column and coresponding teamnumber down the one to the right of it) and using a helper column, insert a VLOOKUP formula to create a TeamNumber column....from there, Copy PasteSpecial Values to get rid of the formulas, and then use the AutoFilter as previously described. Vaya con Dios, Chuck, CABGx3 "bbibib" wrote: Unfortunately, no team number is available!! I wish it was..... Thanks for the reply. CLR wrote: Providing you have a column which indicates "Team Number", then just do Data Filter AutoFilter and select the arrow at the top of the TeamNumber column and choose whichever team you wish to view.......when finished, just do Data Filter Autofilter again to return things to normal.......... hth Vaya con Dios, Chuck, CABGx3 "bbibib" wrote: I have a tab with 60 names in column A with at least 70 entries per person on seperate rows [going from col A to L] These 60 names belong to 5 teams and I would like to be able to run a macro to search for the 12 names per team and then place them onto a seperate tab for each team. That is my ideal, failing that even splitting them into teams on one tab would greatly reduce the time it currently takes to perform this task. Hope someone can help! Thank you. |
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
Search & Refine Raw Data
took it home and have been trying to crack it! I like to try and get
there myself as I hate being beaten - if I don't do it by Monday I will send it, if that's ok. Very kind of you. CLR wrote: I just got home and don't see an email, so I guess you got it sorted........... Vaya con Dios, Chuck, CABGx3 "bbibib" wrote in message ups.com... I was hoping a macro would be the saviour, I'll try the VLOOKUP but that is an area of excel that I am not too familiar with.... Thanks anyway - have to resign myself to a repetitive strain injury! CLR wrote: If you know a list of the names for each of the teams, you could put together a VLOOKUP table (names down one column and coresponding teamnumber down the one to the right of it) and using a helper column, insert a VLOOKUP formula to create a TeamNumber column....from there, Copy PasteSpecial Values to get rid of the formulas, and then use the AutoFilter as previously described. Vaya con Dios, Chuck, CABGx3 "bbibib" wrote: Unfortunately, no team number is available!! I wish it was..... Thanks for the reply. CLR wrote: Providing you have a column which indicates "Team Number", then just do Data Filter AutoFilter and select the arrow at the top of the TeamNumber column and choose whichever team you wish to view.......when finished, just do Data Filter Autofilter again to return things to normal.......... hth Vaya con Dios, Chuck, CABGx3 "bbibib" wrote: I have a tab with 60 names in column A with at least 70 entries per person on seperate rows [going from col A to L] These 60 names belong to 5 teams and I would like to be able to run a macro to search for the 12 names per team and then place them onto a seperate tab for each team. That is my ideal, failing that even splitting them into teams on one tab would greatly reduce the time it currently takes to perform this task. Hope someone can help! Thank you. |
#9
Posted to microsoft.public.excel.misc
|
|||
|
|||
Search & Refine Raw Data
Not a problem.........hope you get there on your own. Sometimes it's easier
tho, if someone shows me the first time...... Vaya con Dios, Chuck, CABGx3 "bbibib" wrote in message oups.com... took it home and have been trying to crack it! I like to try and get there myself as I hate being beaten - if I don't do it by Monday I will send it, if that's ok. Very kind of you. CLR wrote: I just got home and don't see an email, so I guess you got it sorted........... Vaya con Dios, Chuck, CABGx3 "bbibib" wrote in message ups.com... I was hoping a macro would be the saviour, I'll try the VLOOKUP but that is an area of excel that I am not too familiar with.... Thanks anyway - have to resign myself to a repetitive strain injury! CLR wrote: If you know a list of the names for each of the teams, you could put together a VLOOKUP table (names down one column and coresponding teamnumber down the one to the right of it) and using a helper column, insert a VLOOKUP formula to create a TeamNumber column....from there, Copy PasteSpecial Values to get rid of the formulas, and then use the AutoFilter as previously described. Vaya con Dios, Chuck, CABGx3 "bbibib" wrote: Unfortunately, no team number is available!! I wish it was..... Thanks for the reply. CLR wrote: Providing you have a column which indicates "Team Number", then just do Data Filter AutoFilter and select the arrow at the top of the TeamNumber column and choose whichever team you wish to view.......when finished, just do Data Filter Autofilter again to return things to normal.......... hth Vaya con Dios, Chuck, CABGx3 "bbibib" wrote: I have a tab with 60 names in column A with at least 70 entries per person on seperate rows [going from col A to L] These 60 names belong to 5 teams and I would like to be able to run a macro to search for the 12 names per team and then place them onto a seperate tab for each team. That is my ideal, failing that even splitting them into teams on one tab would greatly reduce the time it currently takes to perform this task. Hope someone can help! Thank you. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
sorting 2 colums of numbers and incremening them down | Excel Discussion (Misc queries) | |||
Search Data from one Workbook and copy it into another Workbook | Excel Discussion (Misc queries) | |||
Macro question | Excel Worksheet Functions | |||
Printing data validation scenarios | Excel Worksheet Functions | |||
Sort pages? | Excel Discussion (Misc queries) |