Thread: Collating information in a different location
View Single Post
  #2   Report Post  
Gary L Brown
 
Posts: n/a
Default
Why not...
DataFilterAutofilter
?
HTH,
--
Gary Brown

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


Reply With QuoteReply With Quote