Search & Refine Raw Data

[bbibib]

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.

 

[bbibib]

Unfortunately, no team number is available!!

I wish it was.....

Thanks for the reply.

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

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.

 

[bbibib]

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!

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

Unfortunately, no team number is available!!

I wish it was.....

Thanks for the reply.

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




:

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.

 

[CLR]

I just got home and don't see an email, so I guess you got it
sorted...........

Vaya con Dios,
Chuck, CABGx3

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!

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

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




:

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.

 

[bbibib]

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.

I just got home and don't see an email, so I guess you got it
sorted...........

Vaya con Dios,
Chuck, CABGx3

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!

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



:

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




:

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.

 

[CLR]

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

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.

I just got home and don't see an email, so I guess you got it
sorted...........

Vaya con Dios,
Chuck, CABGx3

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



:

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




:

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.