Search and Copy

[CribbsStyle]

Here's my problem...

I have a worksheet that lists football players, positions and ratings
for each player. I have another worksheet that has sections setup for
each position(QB,WR,RB,etc..). What I would to be able to do is have
excel search for QB,WR,RB,etc.. in B4 to B400 in the "Recruits"
worksheet and then have it copy the entire column for a player to the
"Recruit Ratings" worksheet under the correct section for each player.


Worksheet names
------------------------------------
Recruits - The one where I want to search and copy from
Recruit Ratings - Where the entire columns need to be copied to the
correct sections.


Any help would be greatly appreciated

 

[Otto Moehrbach]

I'll try to help you with this. If you wish, send me your file or a file
that shows what you have. Clearly show what you want to search for, where
to search, and what to do with what is found. Also state the version of
Excel you are using. My email address is (e-mail address removed). Remove the
"nop" from this address. HTH Otto