Collating information in a different location

I have a large sheet (200X200 approx) of individuals that has name, team and a number of Stats.

I need some way of moving details of an entire team (10 rows) data to a different location/sheet. I want to be able to put the team code into a cell and all of the data for that team appears underneath for whichever column required (sales etc)

Can this be done and where to start?

Tom

Why not...
Data>Filter>Autofilter
?
HTH,
--
Gary Brown
gary_brown@ge_NOSPAM.com
If this post was helpful, please click the ''''Yes'''' button next to
''''Was this Post Helpfull to you?".


"tom300181" wrote:

>
> I have a large sheet (200X200 approx) of individuals that has name, team
> and a number of Stats.
>
> I need some way of moving details of an entire team (10 rows) data to a
> different location/sheet. I want to be able to put the team code into a
> cell and all of the data for that team appears underneath for whichever
> column required (sales etc)
>
> Can this be done and where to start?
>
> Tom
>
>
> --
> tom300181
> ------------------------------------------------------------------------
> tom300181's Profile: http://www.excelforum.com/member.php...o&userid=21580
> View this thread: http://www.excelforum.com/showthread...hreadid=392165
>
>

or
Data>Filter>Advanced Filter>Copy to another location
?
HTH,
--
Gary Brown
gary_brown@ge_NOSPAM.com
If this post was helpful, please click the ''''Yes'''' button next to
''''Was this Post Helpfull to you?".


"tom300181" wrote:

>
> I have a large sheet (200X200 approx) of individuals that has name, team
> and a number of Stats.
>
> I need some way of moving details of an entire team (10 rows) data to a
> different location/sheet. I want to be able to put the team code into a
> cell and all of the data for that team appears underneath for whichever
> column required (sales etc)
>
> Can this be done and where to start?
>
> Tom
>
>
> --
> tom300181
> ------------------------------------------------------------------------
> tom300181's Profile: http://www.excelforum.com/member.php...o&userid=21580
> View this thread: http://www.excelforum.com/showthread...hreadid=392165
>
>

Thanks for the response. I'm afraid that auto filters etc will not work as I need to move the data to a different sheet.

Anybody got any ideas on this one?

Thanks

Tom