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.
|